Let' put things this way: if you have to work with many records, it is better if you have a database.
With a database you can query what you need and only this is worthed the effort of using a DB. butterw wrote: > > Hi Alessio, > > Thank you for the sqlite code example. > > What have been the key advantages of using a Database over a > structured array for your applications ? > > http://docs.python.org/library/sqlite3.html : > SQLite is a C library that provides a lightweight disk-based database > that doesn’t require a separate server process and allows accessing > the database using a nonstandard variant of the SQL query language. > > On Sun, Oct 10, 2010 at 12:56 PM, Peter Butterworth <butt...@gmail.com> > wrote: >> 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 with >> data. >> Could you please give more details on the sqlite method you suggest ? >> >> >> -- >>>> by Alessio Civ Oct 10, 2010; 09:04am: >> 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 and plot what >> you need for example. >> >> I can share with you my script to import from csv to sqlite if you want. >> >> >> -- >> thanks, >> peter butterworth >> > > > > -- > thanks, > peter butterworth > > ------------------------------------------------------------------------------ > Beautiful is writing same markup. Internet Explorer 9 supports > standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. > Spend less time writing and rewriting code and more time creating great > experiences on the web. Be a part of the beta today. > http://p.sf.net/sfu/beautyoftheweb > _______________________________________________ > Matplotlib-users mailing list > Matplotlib-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/matplotlib-users > > -- View this message in context: http://old.nabble.com/Best-way-to-use-Excel-Data-tp29908079p29968676.html Sent from the matplotlib - users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Download new Adobe(R) Flash(R) Builder(TM) 4 The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly Flex(R) Builder(TM)) enable the development of rich applications that run across multiple browsers and platforms. Download your free trials today! http://p.sf.net/sfu/adobe-dev2dev _______________________________________________ Matplotlib-users mailing list Matplotlib-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/matplotlib-users
