从读取csv转换为excel - pandas/python
从读取csv转换为excel - pandas/python
提问于 2018-06-27 05:03:15
我还是个新手，所以别对我太客气！
我有一些代码可以很好地处理CSV文件，但我想将它转换为读取excel文件，这样我就可以在每个文件中有多个选项卡。
这是工作原件
import numpy as np
import pandas as pd
import csv
pd.options.mode.chained_assignment = None
#the whole portfolio
num_of_contracts = 1418
num_of_simul = 10000
contract_info_df = pd.read_csv('contract_info..csv', encoding='latin-1')
contract_info_df = contract_info_df.set_index(['Contract Identifier'])
toy_contract = contract_info_df.iloc[:num_of_contracts, :]
toy_contracts_list = contract_info_df.iloc[:num_of_contracts, :].index.tolist()
toy_contracts_list = (list(map(str, toy_contracts_list)))
toy_contract.index = toy_contracts_list
loss_df = pd.read_csv('losstable.csv')
loss_table = loss_df.loc[:,toy_contracts_list][:num_of_simul]
loss_table['row_sum'] = loss_table.sum(axis = 1) 这是我的尝试
import numpy as np
import pandas as pd
pd.options.mode.chained_assignment = None
#the whole portfolio
num_of_contracts = 162
num_of_simul = 10000
xls = pd.ExcelFile('contract_info.xlsx')
df1 = pd.read_excel(xls, 'contract_info') #worksheetname
contract_info_df = df1.set_index(['Contract Identifier'])
toy_contract = contract_info_df.iloc[:num_of_contracts, :]
toy_contracts_list = contract_info_df.iloc[:num_of_contracts, :].index.tolist()
toy_contracts_list = (list(map(str, toy_contracts_list)))
toy_contract.index = toy_contracts_list
xls = pd.ExcelFile('losstable.xlsx')
loss_df = pd.read_excel(xls, 'losstable') #woorksheet name
loss_table = loss_df.loc[:,toy_contracts_list][:num_of_simul]错误出现在最后一行，它找不到列中的'toy_contracts_list‘值
我的问题是什么？
谢谢
回答 1
Stack Overflow用户
发布于 2018-06-27 07:59:07
看起来pd.read_csv('losstable.csv')为列加载了csv 'str‘。而df1 = pd.read_excel(xls, 'losstable')试图推断列的数据类型。在本例中，它将列的数据类型保留为int。
从您的代码中删除这一行：
toy_contracts_list = (list(map(str, toy_contracts_list)))页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/51051335
复制相关文章
相似问题