Python / Pandas:在网络驱动器(Windows)上写入文件
Python / Pandas:在网络驱动器(Windows)上写入文件
提问于 2018-08-02 07:13:35
我正在尝试写入网络驱动器上的文件。我没有收到任何错误，但是文件没有被创建。有什么建议吗？
# Dataframe
df = pd.DataFrame(rwb_list_departments,columns=['Owned By Team','Major Incident','Status','Priority','Incident ID','Owned By','Short Description','Requester Display Name','Created Date Time','Closed Date Time','Department','Duration','NumDur'])
# writing to local drive as csv works great
df.to_csv('rwb_itsm_processed_tickets.csv',index=False,encoding='utf-8')
# Now write file to networked drive as excel
data_folder = Path('W:/CDS Analytics/RWB')
# combine path and file
file_to_write = data_folder / 'rwb_itsm_processed_tickets.xlsx'
# Specify a writer
writer = pd.ExcelWriter('file_to_write', engine='xlsxwriter')
# Write your DataFrame to a file
df.to_excel(writer,'report')
# Save the result
writer.save()回答 1
Stack Overflow用户
发布于 2018-08-02 07:18:50
这就是我让它在我的Mac上工作的方式
# Now write file to networked drive as excel
data_folder ='/Users/myname/Desktop/'
# combine path and file
file_to_write = data_folder + '/rwb_itsm_processed_tickets.xlsx'附言:我无法访问rwb_list_departments，所以我只获取了以下示例数据帧df = pd.DataFrame([[1, 2], [3, 4], [5, 6], [7, 8]], columns=["A", "B"])，该文件与数据帧数据一起创建。Rest所有内容都保持与代码中的相同。错误似乎出在命令Path中，然后是您定义file_to_write的方式
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/51643463
复制相关文章
相似问题