Random. Any Python programmers?

[everything]

Especially if you're using Flask and Pandas?

[origami_itto]

I prefer Django, but whatever. What's the deal

[everything]

Just need to pass uploaded CSV to Pandas. Rather new at this. Using Flask-Excel.

[origami_itto]

Any particular part?

http://flask.pocoo.org/docs/0.11/patterns/fileuploads/
http://pandas.pydata.org/pandas-docs/st ... d_csv.html

[TrainingDummy]

For simple automation scripts and infosec use cases, yes. Don't know anything about Pandas

[everything]

Any particular part?

http://flask.pocoo.org/docs/0.11/patterns/fileuploads/
http://pandas.pydata.org/pandas-docs/st ... d_csv.html

Yes, see http://flask-excel.readthedocs.io/en/latest/

The first part of the example does a jsonify to return JSON of the csv back to the browser. I just want to send it right to Pandas. Pandas has read csv but I don't want to upload the file, put it on disk, then read from disk, necessarily. Don't necessarily want to put it in a database, either. For now, just want to upload and start using Pandas. I realize I can do this locally in Jupyter or whatever but eventually (assuming I can learn fast enough), this will be a web app first for me, then for others.

Thanks for any tips. This is better than stack overflow, haha. RSF comes through again.

[everything]

For simple automation scripts and infosec use cases, yes. Don't know anything about Pandas

cool yeah. I don't know anything about infosec. Pandas is "panel data" for data analysis.

[origami_itto]

Any particular part?

http://flask.pocoo.org/docs/0.11/patterns/fileuploads/
http://pandas.pydata.org/pandas-docs/st ... d_csv.html

Yes, see http://flask-excel.readthedocs.io/en/latest/

The first part of the example does a jsonify to return JSON of the csv back to the browser. I just want to send it right to Pandas. Pandas has read csv but I don't want to upload the file, put it on disk, then read from disk, necessarily. Don't necessarily want to put it in a database, either. For now, just want to upload and start using Pandas. I realize I can do this locally in Jupyter or whatever but eventually (assuming I can learn fast enough), this will be a web app first for me, then for others.

Thanks for any tips. This is better than stack overflow, haha. RSF comes through again.

Those two pages have the meat of it. You can basically copypasta the code on the upload page, then put in a panda.read_csv() and however you want to display it in the return. I'm not overly familiar with pandas, i usually just put anything and everything in MySql.

[everything]

doesn't the read_csv() need to be for a local file? I feel like I should skip the read/write to file or db. But maybe that is silly.

[origami_itto]

Yeah. On the upload you can either store the file locally or pass it to the function as a file like object in memory.

[origami_itto]

file like object
file = request.files['file']

Save as local file
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))

[everything]

ok thanks!

[mrtoes]

Who needs Stackoverflow huh?

[everything]

Who needs Stackoverflow huh?

You can get so many OTT questions answered here LOL

[everything]

ok I got my csv uploaded a a list of lists. very, very random, but does anyone here use the Pandas (data analysis) library?

Edit: figured it out. It's all easy (after you know).