Merge Pandas DataFrames Side by Side 🐼

Combining Pandas DataFrames Horizontally | Merging/Joining Pandas DataFrames | Merging DataFrames side by side
How to combine dataframes side by side

This is the second video in continuation in the series of combining dataframes, which explains -

00:00 - Introduction
00:53 - Combining dataframes side by side using JOIN method of dataframes
02:54 - How to rename the common columns while combining dataframes using JOIN method
06:03 - How to change the index in a dataframe | How to make a column as index in a dataframe using set_index function
08:53 - How to combine dataframes based on a common column using JOIN method
11:40 - How to combine dataframes side by side or horizontally using MERGE method of pandas
12:44 - How to rename the common columns while combining dataframes using MERGE method
14:35 - How to do left join of dataframes using MERGE method
14:57 - How to do join join of dataframes using MERGE method
15:33 - How to join/merge dataframes with specific list of variables only
17:15 - How to combine dataframes using MERGE method based on common column which are named differntly using left_on/right_on parameter

You can download the data used in this video using below:
File Name: - martData.xlsx
URL : - https://github.com/LEARNEREA/Python/tree/main/Data

You can download the script used in this video using below:
Script Name: - Combining DataFrames Using Join or Merge.py
URL : - https://github.com/LEARNEREA/Python/tree/main/Scripts/Pandas

You can check out the previous video in this series using below link:
https://youtu.be/06iGLesHi8g

You can learn join using below link:
https://youtu.be/CajO_tFS5WY

#Learnerea #Python #Pythontutorial #Pythononlinetraining #Pythonforbeginners #PythonProgramming #PythonMatplotlib
#PythonPandas #CombiningDataFrames