Analysis of csv data

136 views
Skip to first unread message

Saransh Mehta

unread,
Apr 10, 2014, 10:43:26 AM4/10/14
to django...@googlegroups.com
I need to analyze the incoming data from the csv file and present it to the user in the best possible way?
What tools do i need to use for analyzing the csv and drawing graphs etc out of the csv?

Jay Parikh

unread,
Apr 10, 2014, 10:54:00 AM4/10/14
to django...@googlegroups.com
Hi Saransh,

Well for just analyzing csv files you can use simple python file io but in order to do more from those extracted data then you could use d3.js for drawing data driven graphs. Could you please provide what kind of csv data you have then probably it would be easy to sort it out.

Best,
Jay


On Thu, Apr 10, 2014 at 4:13 PM, Saransh Mehta <saransh...@gmail.com> wrote:
I need to analyze the incoming data from the csv file and present it to the user in the best possible way?
What tools do i need to use for analyzing the csv and drawing graphs etc out of the csv?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/818ecde6-ab66-48f5-8b2c-8590e9e787be%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Timothy W. Cook

unread,
Apr 10, 2014, 11:03:45 AM4/10/14
to django...@googlegroups.com


On Thu, Apr 10, 2014 at 7:43 AM, Saransh Mehta <saransh...@gmail.com> wrote:
I need to analyze the incoming data from the csv file and present it to the user in the best possible way?
What tools do i need to use for analyzing the csv and drawing graphs etc out of the csv?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/818ecde6-ab66-48f5-8b2c-8590e9e787be%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
MLHIM VIP Signup: http://goo.gl/22B0U
============================================
Timothy Cook, MSc           +55 21 994711995
MLHIM http://www.mlhim.org
Like Us on FB: https://www.facebook.com/mlhim2
Circle us on G+: http://goo.gl/44EV5
Google Scholar: http://goo.gl/MMZ1o
LinkedIn Profile:http://www.linkedin.com/in/timothywaynecook

Julien GODIN

unread,
Apr 10, 2014, 10:48:47 AM4/10/14
to django...@googlegroups.com
I would say a good ol' mycsvdata.split(",") on each line of your CSV and then put all this in a table.

J




On 04/10/2014 12:43 PM, Saransh Mehta wrote:
I need to analyze the incoming data from the csv file and present it to the user in the best possible way?
What tools do i need to use for analyzing the csv and drawing graphs etc out of the csv?

Pedro

unread,
Apr 10, 2014, 10:53:28 AM4/10/14
to django...@googlegroups.com

Can you define what kind of analysis you want to do?
May we supose you know how to load csv data into memory?

Pedro Alves

Em 10/04/2014 07:43, "Saransh Mehta" <saransh...@gmail.com> escreveu:
I need to analyze the incoming data from the csv file and present it to the user in the best possible way?
What tools do i need to use for analyzing the csv and drawing graphs etc out of the csv?

--

Saransh Mehta

unread,
Apr 10, 2014, 6:20:31 PM4/10/14
to django...@googlegroups.com
There are two entities, one that enters the data, say for example marks of some students. Now i'm able to generate the csv of the entered data and i want to present the data in graphical form or anything appealing to the other entity. What should i use to interpret the data from the csv and do the best analysis possible from such a data(marks of the students in this example).

Petite Abeille

unread,
Apr 10, 2014, 6:43:28 PM4/10/14
to django...@googlegroups.com

On Apr 10, 2014, at 12:54 PM, Jay Parikh <jaypa...@gmail.com> wrote:

> you could use d3.js for drawing data driven graphs

Totally.

JSON’ize your CSV appropriately and create, say, a cool Radial Reingold–Tilford Tree:

http://bl.ocks.org/mbostock/4063550

Don’t forget to add some uber-cool animations:

http://mbostock.github.io/d3/talk/20111116/force-collapsible.html

Everybody likes animated Radial Reingold–Tilford Tree. Everybody.

And presto, you got yourself a winner.


Petite Abeille

unread,
Apr 10, 2014, 7:02:23 PM4/10/14
to django...@googlegroups.com

On Apr 10, 2014, at 8:20 PM, Saransh Mehta <saransh...@gmail.com> wrote:

> What should i use to interpret the data from the csv and do the best analysis possible from such a data(marks of the students in this example).

Sometime/most of the time/all the time… what’s most important is the data itself.

Try naked data, it’s simple and healthy:

http://darkhorseanalytics.com/blog/data-looks-better-naked/
http://darkhorseanalytics.com/blog/clear-off-the-table/

If you would like something more, hmmm, interactive, leading to exploration and discovery, nothing quite beat a well constructed PivotTable:

http://en.wikipedia.org/wiki/Pivot_table

Quite a few very popular off-the-shelf softwares handle all of the above rather seamlessly.

Saransh Mehta

unread,
Apr 14, 2014, 12:27:29 PM4/14/14
to django...@googlegroups.com
Thank you.!


On Thursday, April 10, 2014 4:13:26 PM UTC+5:30, Saransh Mehta wrote:
Reply all
Reply to author
Forward
0 new messages