pandas 构建dataframe

1.字典类构建

代码如下（示例）：list(data.index)【行索引】；list(data.columns)【列索引】

import pandas as pd
import numpy as np
dic = {
        "a": [1, 2, 3, 4],             #列表
        "b": np.array([4, 5, 6, 7]),   #数组
        "c": (1, 2, 3, 4)              #元组
      }           
data = pd.DataFrame(dic)            # 创建Dataframe
data
###############################################################
我们也可以在创建Dataframe时手动指定行索引，只需修改参数index：
import pandas as pd
import numpy as np
dic = {
    "a": [1, 2, 3, 4],  # 列表
    "b": np.array([4, 5, 6, 7]),  # 数组
    "c": (1, 2, 3, 4),
}  # 元组
data = pd.DataFrame(dic, index=["一", "二", "三", "四"])  # 创建Dataframe
data
###### 直接替换列索引
data.columns = ["A", "B", "C"]
data

2.Series构成的字典构造Dataframe

代码如下（示例）：

import pandas as pd
import numpy as np
dic = {"a": pd.Series([1, 2, 3, 4]), 
       "b": pd.Series([4, 5, 6, 7])}
data = pd.DataFrame(dic)  # 创建Dataframe
data

3.字典构成的字典构造Dateframe

代码如下（示例）：

import pandas as pd
import numpy as np
dic = {"a": {"一": 1, "二": 2}, 
       "b": {"一": 10, "二": 20}, 
       "c": {"一": 100, "二": 200}}
data = pd.DataFrame(dic)  # 创建Dataframe
data

4.列表类：二维数组构造Dataframe

代码如下（示例）：

import pandas as pd
import numpy as np
ls = np.arange(12).reshape(3, 4)  # 创建二维数组
data = pd.DataFrame(ls)
data

5.列表类：字典列表构造Dataframe

代码如下（示例）：

import pandas as pd
import numpy as np
ls = [{"一": 1, "二": 2}, 
      {"一": 10, "二": 20}, 
      {"一": 100, "二": 200}]
data = pd.DataFrame(ls)
data

6.列表类：Series列表构造Dataframe

代码如下（示例）：

import pandas as pd
import numpy as np
ls = [pd.Series([1, 2, 3, 4]),
      pd.Series([4, 5, 6, 7])]
data = pd.DataFrame(ls)
data

7.列表或数组创建DataFrame

代码如下（示例）：

import pandas as pd
import numpy as np
data = np.array([[1, 2, 3], [4, 5, 6], [7, 8, 9]])
df = pd.DataFrame(data, columns=['A', 'B', 'C'])
print(df)

8.从JSON创建DataFrame

代码如下（示例）：

import pandas as pd
data = '[{"A": 1, "B": 4, "C": 7}, {"A": 2, "B": 5, "C": 8}, {"A": 3, "B": 6, "C": 9}]'
df = pd.read_json(data)
df