python中pandas模块导入csv文件_Python之pandas导入导出数据

1.导入pandas模块

>>> import pandas as pd

2.导入CSV表格数据

>>> titanic = pd.read_csv(r'C:\Users\Administrator\Desktop\titanic.csv')

pandas支持许多不同的文件格式或数据源(csv，excel，sql，json，parquet等)，每种格式都有前缀read_*，将文件的数据读入pandas的DataFrame

3.查看导入数据，显示时DataFrame，默认情况下将显示前5行

>>> titanic

PassengerId Survived Pclass ... Fare Cabin Embarked

0 1 0 3 ... 7.2500 NaN S

1 2 1 1 ... 71.2833 C85 C

2 3 1 3 ... 7.9250 NaN S

3 4 1 1 ... 53.1000 C123 S

4 5 0 3 ... 8.0500 NaN S

.. ... ... ... ... ... ... ...

886 887 0 2 ... 13.0000 NaN S

887 888 1 1 ... 30.0000 B42 S

888 889 0 3 ... 23.4500 NaN S

889 890 1 1 ... 30.0000 C148 C

890 891 0 3 ... 7.7500 NaN Q

4.查看DataFrame的前8行，不指定行数，默认情况下将显示前5行

>>> titanic