Re: [Tutor] Reading CSV files in Pandas

2013-10-21 Thread Manish Tripathi
It's pipeline data so must have been generated through Siebel and sent as excel csv. On Mon, Oct 21, 2013 at 11:32 PM, Danny Yoo wrote: > > > > * Where is this data coming from? > > * Who or what is generating this file? > > > Just to be more specific about this: I have a very strong suspicion

Re: [Tutor] Reading CSV files in Pandas

2013-10-21 Thread Mark Lawrence
On 21/10/2013 22:42, Danny Yoo wrote: This question has now been placed on the correct forum here http://article.gmane.org/gmane.comp.python.pydata/2294 so I see little sense in us attempting to follow it up. -- Python is the second best programming language in the world. But the best has

Re: [Tutor] Reading CSV files in Pandas

2013-10-21 Thread Danny Yoo
On Mon, Oct 21, 2013 at 11:57 AM, Manish Tripathi wrote: > It's pipeline data so must have been generated through Siebel and sent as > excel csv. > > I am assuming that you are talking about "Siebel Analytics", some kind of analysis software from Oracle: http://en.wikipedia.org/wiki/Siebel_Sy

Re: [Tutor] Reading CSV files in Pandas

2013-10-21 Thread Danny Yoo
> > * Where is this data coming from? > * Who or what is generating this file? Just to be more specific about this: I have a very strong suspicion that whatever is generating the input that you're trying to read is doing something ad-hoc with regards to CSV file format. Knowing what generated th

Re: [Tutor] Reading CSV files in Pandas

2013-10-21 Thread Danny Yoo
On Sat, Oct 19, 2013 at 7:29 AM, Manish Tripathi wrote: > > I am trying to import a csv file in Pandas but it throws an error. The format of the data when opened in notepad++ is as follows with first row being column names: > > "End Customer Organization ID,End Customer Organization Name,End Custo

Re: [Tutor] Reading CSV files in Pandas

2013-10-21 Thread Mark Lawrence
On 21/10/2013 04:05, Sivaram Neelakantan wrote: you could try the following newsgroup or mailing list for more specialised help. gmane.org:gmane.comp.python.pydata sivaram -- Thanks for this, it explains why I couldn't find pandas there :) -- Python is the second best programming lang

Re: [Tutor] Reading CSV files in Pandas

2013-10-20 Thread Sivaram Neelakantan
On Sat, Oct 19 2013,Manish Tripathi wrote: > I am trying to import a csv file in Pandas but it throws an error. The > format of the data when opened in notepad++ is as follows with first row > being column names: you could try the following newsgroup or mailing list for more specialised help.

Re: [Tutor] Reading CSV files in Pandas

2013-10-20 Thread Sivaram Neelakantan
On Sun, Oct 20 2013,Mark Lawrence wrote: > On 19/10/2013 23:40, Alan Gauld wrote: > >> This is the second time I've seen pandas mentioned recedntly I really >> must go and look it up to find out what it is... > > Just started out myself at http://pandas.pydata.org/ and at first > glance it seems q

Re: [Tutor] Reading CSV files in Pandas

2013-10-20 Thread Albert-Jan Roskam
On Sun, 10/20/13, Mark Lawrence wrote: Subject: Re: [Tutor] Reading CSV files in Pandas To: tutor@python.org Date: Sunday, October 20, 2013, 1:16 AM On 19/10/2013 23:40, Alan Gauld wrote: > This is the second time I've seen pandas mentioned recedntly I really > must go and

Re: [Tutor] Reading CSV files in Pandas

2013-10-20 Thread John Steedman
I have in front of me a copy an (unread, borrowed) copy of "Python for Data Analysis". Well, on page 104, there is the start of an answer. Pandas : has two useful functions: read_csv and read_table Numpy : see np.loadtxt and np.genfromtxt There is an example for using the first numpy function:

Re: [Tutor] Reading CSV files in Pandas

2013-10-20 Thread Alan Gauld
On 20/10/13 11:30, Matthew Ngaha wrote: Does pandas do the same thing numpy does? Pandas is more about analysis of big data volumes rather than complex calculations. eg statistical analysis and data mining. As such it's closer to R than to numpy in its function, so far as I can tell. (Altho

Re: [Tutor] Reading CSV files in Pandas

2013-10-20 Thread Mark Lawrence
On 20/10/2013 11:30, Matthew Ngaha wrote: Does pandas do the same thing numpy does? I've never used them and unsure of what they are about. ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/ma

Re: [Tutor] Reading CSV files in Pandas

2013-10-20 Thread Matthew Ngaha
Does pandas do the same thing numpy does? I've never used them and unsure of what they are about. ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor

Re: [Tutor] Reading CSV files in Pandas

2013-10-20 Thread Manish Tripathi
Thanks Mark. I have already asked this question on StackOverflow but to no avail. So thought of asking here. On Sun, Oct 20, 2013 at 5:47 AM, Mark Lawrence wrote: > On 19/10/2013 15:29, Manish Tripathi wrote: > > You are far more likely to get a response to the identical question that > you've a

Re: [Tutor] Reading CSV files in Pandas

2013-10-19 Thread Mark Lawrence
On 19/10/2013 15:29, Manish Tripathi wrote: You are far more likely to get a response to the identical question that you've already asked on stackoverflow than you are here. -- Roses are red, Violets are blue, Most poems rhyme, But this one doesn't. Mark Lawrence

Re: [Tutor] Reading CSV files in Pandas

2013-10-19 Thread Mark Lawrence
On 19/10/2013 23:40, Alan Gauld wrote: This is the second time I've seen pandas mentioned recedntly I really must go and look it up to find out what it is... Just started out myself at http://pandas.pydata.org/ and at first glance it seems quite awesome. -- Roses are red, Violets are blue,

Re: [Tutor] Reading CSV files in Pandas

2013-10-19 Thread Alan Gauld
On 19/10/13 15:29, Manish Tripathi wrote: I am trying to import a csv file in Pandas but it throws an error. This is the second time I've seen pandas mentioned recedntly I really must go and look it up to find out what it is... Meanwhile can you clarify what you mean by importing the csv fil

[Tutor] Reading CSV files in Pandas

2013-10-19 Thread Manish Tripathi
I am trying to import a csv file in Pandas but it throws an error. The format of the data when opened in notepad++ is as follows with first row being column names: "End Customer Organization ID,End Customer Organization Name,End Customer Top Parent Organization ID,End Customer Top Parent Organizat