pandas读文件
df = pd.read_excel(filename,sheet_name=0,usecols=[1],header=None)
tolist()
mylist = df.values.tolist()
转成1个list列表
不转的话,你会得到n个列表,而不是一个
users=[]
for i in mylist:
users.append(i[0])
import pandas as pd
import numpy as np
from pathlib import Path
filename = Path("/Users/2737.xlsx")
# read the file使用哪列:usecols参数从0开始
df = pd.read_excel(filename,sheet_name=0,usecols=[1],header=None)
mylist = df.values.tolist()
users=[]
for i in mylist:
users.append(i[0])
print(users)