Re: [Matplotlib-users] Scatter Plot with different colors

2010-10-10 Thread Alessio Civ
Thanks Goyo and Jae-Joon Lee. It worked! it worked! Goyo wrote: > > 2010/10/10 Alessio Civ : >> >> >> Please, can someone help me? I've been digging the documentation, but I >> can't find a way to do this. > > ¿Didn't you get my message on oct-5? I didn't send it to the list by > mistake: >

Re: [Matplotlib-users] Scatter Plot with different colors

2010-10-10 Thread Alessio Civ
Hi, thanks for reply. My problem is that I need to scatter data of different periods but in the same x. For example, the quantity x sold in March is 1 at price y of 2, the quantity sold in April is 2 at price y of 3. I want the 2 points to have different colors in the same graph! Now I'm doing

Re: [Matplotlib-users] Best way to use Excel Data

2010-10-10 Thread Alessio Civ
Hi Butterw, first of all, if you are working on data a lot, we could get in contact. I need to work better on my scripts and we could help each other. I've uploaded my script that imports from csv to sqlite. It's not a totally clean script, as I am working on something else now I couldn't clean

Re: [Matplotlib-users] Best way to use Excel Data

2010-10-10 Thread Peter Butterworth
Hi, To load csv data, I use a modified version of csv2rec for which the data type of each column is specified explicitly in the data file. By removing the dtype guessing you get a speedup and you also avoid potential mess-ups. Alessio: sadly you right about it not being possible to trust Excel

Re: [Matplotlib-users] Scatter Plot with different colors

2010-10-10 Thread Goyo
2010/10/10 Alessio Civ : > > > Please, can someone help me? I've been digging the documentation, but I > can't find a way to do this. ¿Didn't you get my message on oct-5? I didn't send it to the list by mistake: --%< Make

Re: [Matplotlib-users] Best way to use Excel Data

2010-10-10 Thread Alessio Civ
Hi, a strong advice from someone who is using excel format with tons of data is to save them in csv and then import in Sqlite. Excel messes up the data types and gives a lot of troubles with numbers. Sqlite is fast and data are secure. The power of this system is that you can query your data an