excel内容
- 读取一列保存为list,项目名称为例:
import pandas as pd
def excel_one_line_to_list():
df = pd.read_excel(“/Users/Devintern/Documents/pachong/ML_flow/pachong/qmp/files/投资事件导出20190303.xlsx”, usecols=[1],
names=None) # 读取项目名称列,不要列名
df_li = df.values.tolist()
result = []
for s_li in df_li:
result.append(s_li[0])
print(result)
if name == ‘main‘:
excel_one_line_to_list()
运行结果
[’51有色’, ‘优生国际’, ‘名片侠’, ‘约珥传媒’]
- 读取两列保存为list,项目名称和行业领域为例:
import pandas as pd
def excel_one_line_to_list():
df = pd.read_excel(“/Users/Devintern/Documents/
Original: https://blog.csdn.net/weixin_42496802/article/details/113499129
Author: 鸭梨梨呐
Title: pythonpandas读取多列数据为一列_Python+Pandas读取excel一列或者多列保存为列表
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/679697/
转载文章受原作者版权保护。转载请注明原作者出处!