|
20鱼币
问题1:目前代码只能提取分析并打印excel文件到IDLE中,请问如何能将提取的这部分数据保存为指定位置TXT文本,然后关闭这个excel文件(原excel文件不作修改)?
问题2:打开excel文件不指定文件名,只指定位置和xlsx格式,从存放位置中打开选取,要如何修改?
excel文件禁止上传?
import pandas as pd
df = pd.read_excel('阀门(化工厂).xlsx',sep='?',skiprows=[0,1])
df.head()
data1 = []
data2 = []
result = []
data1=df.ix[2,6]
if '/' in data1:
data1==' '
else:
data1==data1+(14-len(data1))*' '
data2=df.ix[2,13]
if '/' in data2:
data2==' '
data2.append(line_spoken)
elif '单' in data2:
result=='SR'
else:
result=='DA'
print(' '*14,data1, data2, end='')
#df.close()
本帖最后由 XiaoPaiShen 于 2019-9-25 01:00 编辑
- import pandas as pd
- import easygui as g
- # excel_file = '阀门(化工厂).xlsx'
- excel_file = g.fileopenbox(msg=None, title=None, default="D:/Document/Python/Lianxi/*.xlsx", filetypes=None, multiple=False)
- df = pd.read_excel(excel_file,sep='?',skiprows=[0,1])
- cols = ['阀体', '执行机构']
- df_list_two = df[cols]
- data1 = []
- data2 = []
- for index, row in df_list_two.iterrows():
- print(row['阀体'], row['执行机构'])
- # business logic
- if '/' in row['阀体']:
- data1.append(' ' * 14)
- else:
- data1.append(row['阀体'])
- if '/' in row['执行机构']:
- data2.append(' ' * 14)
- else:
- data2.append(row['执行机构'])
- txt_file = g.filesavebox(msg=None, title=None, default="D:/Document/Python/Lianxi/*.txt", filetypes=None)
- write_file = open(txt_file, mode='wt', encoding='UTF-8')
- for index in range(len(data1)):
- write_line = data1[index] + data2[index] + '\n'
- write_file.write(write_line)
- write_file.close()
复制代码
请根据你的业务逻辑修改cols, row[' '], 以及循环中的逻辑,你贴的代码没明白业务逻辑,我没百度网盘的账号,只好照着图片模仿。。。
|
最佳答案
查看完整内容
请根据你的业务逻辑修改cols, row[' '], 以及循环中的逻辑,你贴的代码没明白业务逻辑,我没百度网盘的账号,只好照着图片模仿。。。
|