[Tutor] toy program to find standard deviation of 2 columns of a sqlite3 database

[Alan Gauld]

On 03/07/2022 14:01, Manprit Singh wrote:
> Sir,
> I am just going through all the functionalities available in sqlite3 module
> , just to see if I can use sqlite3 as a good data analysis tool or not .

SQLite is a good storage and retrieval system. It's not aimed at data
analysis, thats where tools like Pandas and R come into play.

SQLite will do a better job in pulling out specific subsets of
data and of organising your data with relationships etc. But it
makes no attempt to be a fully featured application environment
(unlike the bigger client/server databases like Oracle or DB2)

> Upto this point I have figured out that and sqlite data base file can be an
> excellent replacement for data stored in files .
> 
> You can preserve data in a structured form, email to someone who need it
> etc etc .

Yes, that is its strong point. Everything is stored in a single file
that can be easily shared by email or by storing it on a cloud server.

> But for good data analysis ....I found pandas is superior . I use pandas
> for data analysis and visualization .

And that's good because that is what Pandas (and SciPy in general)
is  designed for.
> 
> Btw ....this is true . You should use right tool for your task .

Absolutely. One of the key skills of a software engineer is
recognising which tools are best suited to which part of the
task and how to glue them together.
There is no universally best tool.

-- 
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.amazon.com/author/alan_gauld
Follow my photo-blog on Flickr at:
http://www.flickr.com/photos/alangauldphotos