我在django中创建了一个CSV文件,当你得到一个url,它会下载CSV文件,它工作得很好,唯一的事情是,当文件被写入时,它被存储在内存中,而不是硬盘中。如何使用导入csv执行此操作
这适用于使用list创建csv的django
def data_feed_file(request):
open_publications = self.get_publications(user_context)
with open('facebook_feed.csv', 'wb') as csvfile:
filewriter = csv.writer(csvfile, delimiter=',', quotechar='|', quoting=csv.QUOTE_MINIMAL)
filewriter.writerow(['id', 'title','description'])
for op_pub in open_publications:
filewriter.writerow([op_pub.id, op_pub.name, str(op_pub.description)])
with open('facebook_feed.csv', 'rb') as myfile:
response = HttpResponse(myfile, content_type='text/csv')
response['Content-Disposition'] = 'attachment; filename=facebook_feed.csv'
return response发布于 2019-01-26 00:21:36
您可以将csv文件保存在pandas DataFrame中。如下所示:
import pandas as pd
df = pd.read_csv('url_to_csv')然后csv由pandas库读取,您不必将其保存到驱动器。
https://stackoverflow.com/questions/54369016
复制相似问题