Mini Program 5 - Connecting SQLite DB using Python

Have you observed that Knowddy and Hairbrow keeps changing their shapes and size? However, rest assure their characteristics - continuous learning remains the same. The same is with the data. You can save them as excel and perform data manipulations or store them as dataframe and perform the analysis. Another way is to push the data into sql tables and write your queries to get the insights. We see that Python is robust enough to allow you to connect to a database and perform all the sql operations. The study buddies have tried and tested this using a light weight database - sqllite. 

Do you want to try sqllite connections in Python with them? Below is the pseudo code for you to experiment with and here is the link to their version (GitHub Code)


All visuals are created using Canva

Comments

Post a Comment

Popular posts from this blog

Mini Program 14 - Health Insurance Data Analysis & Model building using Python - Part 1

Image
Data Science domain has grown rapidly since past few years with industries realizing that the data stored can be put to best use, to help them grow their business. People who understands the data, can play around with the data and build insights from them are in great demands. You must have heard about roles like Data Scientist, Data Analysts and Machine learning engineers to name a few. Today, we will learn how to analyze the data and to build predictive analytics models using Python.  Here, we have come up with simple and easy to understand tutorial for analyzing health insurance dataset. #CodeWithUs to find out more and do it your self!!  You can find the code at  Python Code - GitHub               
Read more

Mini Program 15 - Health Insurance Data Analysis & Model building using Python - Part 2

Image
Data Cleaning and Exploratory Data Analysis are crucial parts in any data science project. It is rightly said that if we give junk input to the model, we will get a junk output. The dataset may have missing values or outliers which should be identified and treated during data cleaning phase. These are only a few examples of un-clean data. A data analyst find hundreds of anomalies in the dataset while analyzing. Exploratory data analysis is done to get the hidden insights from the data. Data Analysts perform univariate and multi-variate analysis to understand the pattern in the dataset.  We are  analyzing health insurance dataset in this case study.  You can follow this post to know how to get started. #CodeWithUs to find out more and do it your self!!  You can find the code at  Python Code - GitHub  
Read more

Mini Program 16 - Health Insurance Data Analysis & Model building using Python - Part 3

Image
Univariate and Multivariate analysis of the data is an important step during Exploratory Data Analysis phase of the data science project. We can target analyzing numerical and categorical variables separately before performing multivariate analysis. More we know the data, better it becomes during Model Building phase. We are  analyzing health insurance dataset in this case study.  You can follow  this  post to know how to get started. #CodeWithUs to find out more and do it your self!!  You can find the code at  Python Code - GitHub
Read more