JIYIK CN >

We will cover methods for dictionaryconverting Python to Pandas , as well as options for using as and as values ​​and converting nested to .datafarmekeyscolumnsvaluesrowdictionaryDataFrame

We will also introduce another method using pandas.DataFrame.from_dict to chain it with any of the rename methods and set the names of the index and columns in one go.

Methods for 字典converting to PandasDataFame

Pandas DataFrame Constructor pd.DataFrame()If you pass dictionary items as arguments to the constructor instead of the dictionary itself, then the dictionary is converted to a dataframe.

# python 3.x
import pandas as pd

fruit_dict = {3: "apple", 2: "banana", 6: "mango", 4: "apricot", 1: "kiwi", 8: "orange"}

print(pd.DataFrame(list(fruit_dict.items()), columns=["Quantity", "FruitName"]))

键The sum of the dictionaries 值will be converted DataFrameto two columns with the column names 列given in the options.

   Quantity FruitName
0         3     apple
1         2    banana
2         6     mango
3         4   apricot
4         1      kiwi
5         8    orange

Methods to 键Convert to and from in Pandas DataFrame列值行

We can simply put the dictionary in square brackets and remove the column names from the above code, like this:

import pandas as pd

fruit_dict = {1: "apple", 2: "banana", 3: "mango", 4: "apricot", 5: "kiwi", 6: "orange"}

print(pd.DataFrame([fruit_dict]))

Output:

       1       2      3        4     5       6
0  apple  banana  mango  apricot  kiwi  orange

We will use pandas's 字典推导sum concatto combine all of them 字典, and then pass the list to use the new列名

Consider the following code,

import pandas as pd

data = {"1": {"apple": 11, "banana": 18}, "2": {"apple": 16, "banana": 12}}
df = pd.concat({k: pd.Series(v) for k, v in data.items()}).reset_index()
df.columns = ["dict_index", "name", "quantity"]
print(df)

Output:

  dict_index    name  quantity
0          1   apple        11
1          1  banana        18
2          2   apple        16
3          2  banana        12

pandas.DataFrame().from_dict()Method to convert dict to dataframe

We will use from_dict to convert the dict to a dataframe, here we set orient = index to use the dictionary keys as rows and use rename()the method to change the column names.

Consider the following code,

import pandas as pd

print(
    pd.DataFrame.from_dict(
        {"apple": 3, "banana": 5, "mango": 7, "apricot": 1, "kiwi": 8, "orange": 3},
        orient="index",
    ).rename(columns={0: "Qunatity"})
)

Output:

         Quantity
apple           3
banana          5
mango           7
apricot         1
kiwi            8
orange          3