To do this Pandas makes our task very easy. Pandas provide various functions as listed below using which we can merge datasets seamlessly:
Here we will be discussing about how to connect to the database using SQLAlchemy package and create database, create tables in database, Inserting data in the tables, various ways to select data from the table, Delete operations, update operations and lot more.
This post assumes that reader has basic knowledge about SQL.
- Creating a dataset from lists
- Using the plot function of pandas
- Pandas with time series
- Reindexing the index in pandas
- Resampling of data
- Chaining and filtering
- Grouping of data
- Transforming data
Cleaning of data is one of the crucial step in the entire process of creating machine learning model.
Let's get started and master the crucial process of cleaning datasets.