【读取EXCEL文件】

读取excel文件的包和方法

1. 导入pandas

# _*_ encoding:utf-8 _*_
import xlrd
import pandas as pd

excel_path = r'abc.xlsx'
sheet_name = 'Sheet1'
sheet_name2 = 'Sheet2'


def excel_r(sheet):
    # xlrd不好用，对于读取excel文件
    # file = xlrd.open_workbook(excel_path)
    # data = file.sheet_by_name(sheet_name)

    # 创建excel文件对象
    file = pd.ExcelFile(r'abc.xlsx')
    print(file)

    # 读取excel文件数据（指定sheet）
    data = pd.read_excel(file, sheet)
    print(data)
    # count(0)代表获取每一列的数量
    print(data.count(0))
    print(data.count(0)[0])
    # count(1)代表获取每一行的数量
    print(data.count(1))
    print(data.count(1)[0])

    # 分别获取每个栏位的值
    for name in data.get('name'):
        print(name)


if __name__ == '__main__':
    excel_r(sheet_name)

<pandas.io.excel._base.ExcelFile object at 0x0000016A53066A90>
       name  age     sex      job
0  zhangsan   20    male  engneer
1      lisi   30  female   worker
2    wangwu   40    male   doctor
name    3
age     3
sex     3
job     3
dtype: int64
3
0    4
1    4
2    4
dtype: int64
4
zhangsan
lisi
wangwu

Process finished with exit code 0