Send pandas dataframe as csv using Falcon

Question

I currently have a pandas dataframe, I want it to get downloaded when you hit an API endpoint using Falcon. Currently I have following code.

data = df
resp.status = falcon.HTTP_200
resp.stream = data
resp.content_type = 'text/csv'

How can send the contents of my dataframe over the network to so that it gets downloaded when you hit the API endpoint? Any help is Appreciated! Thanks!

Could you suggest any good links to the documentation that shows me how to do so/ — howard roark, Aug 26 '17 at 05:46
I want to host so that clients could hit the end points and download it — howard roark, Aug 26 '17 at 06:17
And alternatively: http://falcon.readthedocs.io/en/stable/user/tutorial.html# — cs95, Aug 26 '17 at 06:20

score -1 · Answer 1 · answered Aug 26 '17 at 04:56

-1

First you must transform the DataFrame into something suitable for sending. Easiest is probably to_json(): https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_json.html because JSON is the easiest language to parse in most web clients.

answered Aug 26 '17 at 04:56

John Zwinck

223,042
33
293
407

I am able to send it as json, I need to send it as a csv – howard roark Aug 26 '17 at 05:04
Well then use `to_csv()`. – John Zwinck Aug 26 '17 at 13:31
I tried it doesn't download as csv. There is no file extension to the downloaded file – howard roark Aug 26 '17 at 14:13

Send pandas dataframe as csv using Falcon

1 Answers1