in memory dataframe to binary blob (eg. flask)

send_dataframe_as_csv.py

from io import BytesIO, StringIO

import pandas as pd
from flask import send_file, Flask

server = Flask(__name__)


@server.route("/download/", defaults=dict(name="file"))
@server.route("/download/<name>")
def send_dataframe_as_csv(name):
    df = pd.DataFrame()

    proxy = StringIO()
    df.to_csv(proxy, index=False)

    output = BytesIO()
    output.write(proxy.getvalue().encode("utf-8"))

    output.seek(0)
    proxy.close()

    filename = "{}.csv".format(name)

    return send_file(output, as_attachment=True, attachment_filename=filename)