今天,我们继续解读pandas中read_excel的参数,重点查看skiprows,nrows,skipfooter等三个参数
下面是pandas文档的说明:
skiprows : list-like
Rows to skip at the beginning (0-indexed).
nrows : int, default None
Number of rows to parse.
skipfooter : int, default 0
Rows at the end to skip (0-indexed).
下面请看详细举例:
>>> import pandas as pd
>>> df = pd.read_excel(r'D:/myExcel/1.xlsx', sheet_name='Sheet1', verbose=True)
Reading sheet Sheet1
>>> df
name math Chinese id
0 bob 23.0 12 123
1 millor 32.0 32 124
2 jiken 61.0 89 125
3 tom 34.0 94 126
4 json NaN 12 127
5 dela 96.0 67 128
6 rison 90.0 34 129
# skiprows指的是跳过前3行,然后从第四行开始解读为header,然后后续开始添加index
>>> df = pd.read_excel(r'D:/myExcel/1.xlsx', sheet_name='Sheet1', skiprows=3)
>>> df
jiken 61 89 125
0 tom 34.0 94 126
1 json NaN 12 127
2 dela 96.0 67 128
3 rison 90.0 34 129
# nrows指的是只读几行,nrows=3指的是从header下一行开始,读3行
>>> df = pd.read_excel(r'D:/myExcel/1.xlsx', sheet_name='Sheet1', nrows=3)
>>> df
name math Chinese id
0 bob 23 12 123
1 millor 32 32 124
2 jiken 61 89 125
# skipfooter=2指的是倒数2行不进行解析
>>> df = pd.read_excel(r'D:/myExcel/1.xlsx', sheet_name='Sheet1', skipfooter=2)
>>> df
name math Chinese id
0 bob 23.0 12 123
1 millor 32.0 32 124
2 jiken 61.0 89 125
3 tom 34.0 94 126
4 json NaN 12 127
哈哈,以上就是python小工具今天对read_excel()方法的3个参数的解释。如果有兴趣,欢迎关注我的公众号:python小工具。一起努力让办公变得简单一点。