![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/726bedbee7363e7531655ff4a6e26aa8.png)
以上图片截取自利用python进行数据分析的中文翻译。感谢翻译者。
构造DataFrame的数据格式
import pandas as pd
import numpy as np
二维ndarray
arr2d = np.random.randint(0,9,size=(5,4))
arr2d
array([[6, 3, 0, 4],
[2, 5, 5, 0],
[3, 7, 6, 5],
[8, 3, 7, 6],
[8, 4, 2, 6]])
df_arr2d = pd.DataFrame(arr2d)
df_arr2d
|
0 |
1 |
2 |
3 |
0 |
6 |
3 |
0 |
4 |
1 |
2 |
5 |
5 |
0 |
2 |
3 |
7 |
6 |
5 |
3 |
8 |
3 |
7 |
6 |
4 |
8 |
4 |
2 |
6 |
cols = ['A','B','C','D']
idx = ['a','b','c','d','e']
df_arr2d = pd.DataFrame(arr2d,index=pd.Index(idx),columns=cols)
df_arr2d
|
A |
B |
C |
D |
a |
6 |
3 |
0 |
4 |
b |
2 |
5 |
5 |
0 |
c |
3 |
7 |
6 |
5 |
d |
8 |
3 |
7 |
6 |
e |
8 |
4 |
2 |
6 |
由数组、列表或元组组成的字典
所有序列长度必须相同
数组组成的字典
import random
arr1 = np.random.randint(0,9,size=10)
arr2 = np.random.randint(0,9,size=10)
arr3 = np.random.randint(0,9,size=10)
dic_array = {
'A':arr1,'B':arr2,'C':arr3}
DF_dic_array = pd.DataFrame(dic_array)
DF_dic_array
|
A |
B |
C |
0 |
1 |
4 |
2 |
1 |
2 |
2 |
1 |
2 |
0 |
2 |
2 |
3 |
6 |
3 |
1 |
4 |
2 |
4 |
4 |
5 |
3 |
4 |
5 |