Pandas数据分析：导入数据

准备工作

pip install xlrd

pip install openpyxl

导入xlsx文件

基本导入

import pandas as pd

df = pd.read_excel(r'test1.xlsx')

print(df)

输出：

   编号  年龄  性别       注册时间
0   0  A1  54 2021-08-01
1   1  A2  16 2021-08-02
2   2  A3  47 2021-08-03
3   3  A4  41 2021-08-04

指定工作表

import pandas as pd

df = pd.read_excel(r'test1.xlsx',sheet_name='Sheet1')

print(df)

确定索引列

import pandas as pd

df = pd.read_excel(r'test1.xlsx',sheet_name='Sheet1')

print(df)

确定索引行

import pandas as pd

df = pd.read_excel(r'test1.xlsx',header =1)

print(df)

指定导入列

import pandas as pd

df = pd.read_excel(r'test1.xlsx',usecols = [0,2])

print(df)