1.DataFrame是Series的容器,我们看一看怎么就是容器了
![6eef0ff232d51ed06e63b3822d217b26.png](https://i-blog.csdnimg.cn/blog_migrate/d04aaca1a65adab9d2d227e30922841c.jpeg)
import pandas as pdimport numpy as npa=pd.DataFrame(np.arange(24).reshape((4,6)))print(a)
运行结果如下,我们可以看见结果是一个有行,列索引的
D:pythonpython.exe F:/data_analysis/pandas5_DataFrame.py 0 1 2 3 4 50 0 1 2 3 4 51 6 7 8 9 10 112 12 13 14 15 16 173 18 19 20 21 22 23进程已结束,退出代码 0
2.跟series一样,我们也可以对DataFrame也可以指定索引名
![eb68f026098dcf0d80272b708907eaf9.png](https://i-blog.csdnimg.cn/blog_migrate/b1166f32f1a6ea1592cf162542cbb75c.jpeg)
import pandas as pdimport numpy as npimport string#创建DataFrame对象a=pd.DataFrame(np.arange(24).reshape((4,6)))print(a)#指定索引名b=pd.DataFrame(np.arange(24).reshape((4,6)),index=list(string.ascii_uppercase)[:4], columns=range(6))print(b)
运行结果:
D:pythonpython.exe F:/data_analysis/pandas5_DataFrame.py 0 1 2 3 4 50 0 1 2 3 4 51 6 7 8 9 10 112 12 13 14 15 16 173 18 19 20 21 22 23 0 1 2 3 4 5A 0 1 2 3 4 5B 6 7 8 9 10 11C 12 13 14 15 16 17D 18 19 20 21 22 23进程已结束,退出代码 0
3.通过字典创建DataFrame有两种形式
3-1字典中包含列表:
import pandas as pd#字典创建dataframedict={"name":["xiaoming","xiaogang"],"age":[16,36],"tel":[10086,10010]}c=pd.DataFrame(dict)print(c)
运行结果:
D:pythonpython.exe F:/data_analysis/pandas5_DataFrame_create.py name age tel0 xiaoming 16 100861 xiaogang 36 10010进程已结束,退出代码 0
3-2列表中包含字典
import pandas as pd#列表中包含字典list=[{"name":"xiaoming","age":20,"tel":10086}, {"name":"xiaohong","tel":10010}, {"name":"xiaogang","age":18}]d=pd.DataFrame(list)print(d)
运行结果,没有值的用nan补充
D:pythonpython.exe F:/data_analysis/test.py name age tel0 xiaoming 20.0 10086.01 xiaohong NaN 10010.02 xiaogang 18.0 NaN进程已结束,退出代码 0