使用Flask发送多个CSV吗? [英] Send with multiple CSVs using Flask?

问题描述

我有一个应用程序，其中包含一些信息，使用熊猫进行一些计算，然后将最终的熊猫数据框转换为CSV，然后使用Flask应用下载.如何在一个视图中下载多个CSV?看来我一次只能返回一个响应.

I have an app that takes in some information, performs some calculations using pandas, and turns the final pandas data frame into a CSV that is then downloaded using the Flask app. How do I download multiple CSVs within one view? It seems that I can only return a single response at a time.

示例片段:

def serve_csv(dataframe,filename):
    buffer = StringIO.StringIO()
    dataframe.to_csv(buffer, encoding='utf-8', index=False)
    buffer.seek(0)
    return send_file(buffer,
             attachment_filename=filename,
             mimetype='text/csv')

def make_calculation(arg1, arg2):
   '''Does some calculations.
   input: arg1 - string, arg2- string
   returns: a pandas data frame'''

@app.route('test_app', methods=['GET', 'POST'])
def test_app():
    form = Form1()
    if form.validate_on_submit():
    calculated_dataframe = make_calculation(str(form.input_1.data), str(form.input_2.data))
        return serve_csv(calculated_dataframe, 'Your_final_output.csv')
    return render_template('test_app.html', form=form)

因此，在上面的示例中，我们说 make_calculation 返回了两个熊猫数据帧.我如何将它们都打印为CSV?

So let's say in that example above that make_calculation returned two pandas data frames. How would I print both of them to a CSV?

推荐答案

您可以返回 MIME多部分响应，一个zip文件或TAR球(请注意，链接的RFC有点过时了，但是由于它是HTML格式，因此更容易快速上手；官方名称是

You could return a MIME Multipart response, a zip file, or a TAR ball (please note the linked RFC is somewhat out of date, but is easier to quickly get up to speed with because it's in HTML; the official one is here).

如果您选择执行MIME多重响应，那么一个很好的起点可能是查看请求中的"coder.py" rel ="noreferrer"> MultipartDecoder 工具带；您可能可以直接使用它们，或者至少使用它们的子类/组成来获得所需的行为. Zip文件和

If you choose to do a MIME multipart response, a good starting point might be to look at the MultipartEncoder and MultipartDecoder in requests toolbelt; you may be able to use them directly, or at least subclass/compose using those to get your desired behavior. Zip files and TAR balls can be implemented using standard library modules.

一种替代方法是设计您的API，以便您返回JSON，使用标头(或XML元素或JSON字段)表示可以通过另一个请求或类似请求获得其他CSV.

An alternative would be to design your API so that you were returning JSON, use a header (or XML element or JSON field) to indicate that additional CSVs could be obtained by another request, or similar.

这篇关于使用Flask发送多个CSV吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！