This is the 3 post in the series of Pandas and SQL command line similarity, link to first and second post are
Finding unique values from the datasets
We can find unique value and its count for a column with the help of below command, this may be required for in-depth data analysis.
Adding column to existing datasets
Sometimes we have to add new column to complete the analysis, procedure to add new column in Pandas and SQL are
This command will add empty column to the existing data frame with data type Object.
Finding Mean,SUM,Min and Max values of column
The statistical values play important role in the data analysis to develop Machine learning model, the commands to find them are
Drop the column/s
We have to drop some column/s during data analysis which may be irrelevant in developing Machine learning models. The command from Pandas and SQL are
Hope you enjoyed this 3 article to find out Pandas and SQL command line similarity, Stay tuned for the final article. You can find same article on Medium.com here.