Python Pandas Tutorial | Concatenate Pandas Dataframe - P12

Python Pandas Tutorial | Concatenate Pandas Dataframe - P12
#technologycult #pythonformachinlearning #pythonpandas

Topic to be covered :
Concatenate Dataframes

Table of Content
00:31 Import the libraries Pandas and Numpy
01:15 Create the dataframe and load the data
01:46 how to use Pandas pd.concat to concatenate the dataframes when axis = 0
02:50 how to use Pandas pd.concat to concatenate the dataframes when axis = 1
05:47 how to append record to a dataframe

Concatenating Dataframes

df1 = pd.DataFrame()
ID = [1001,1002,1003,1004]
Name = ['Virat Kohli','Susan Whistler','Micheal Scofield', 'Sarah Wilson']
Gender = ['Male','Male','Male','Female']
Country = ['India','Australia','England','Canada']

df1['ID'] = ID
df1['Name'] = Name
df1['Gender'] = Gender
df1['Country'] = Country

df2 = pd.DataFrame()
ID = [2001,2002,2003,2004]
Name = ['Ramos Djavedi','Sanjeev Walia','Sneha Chowdhury','Lincoln Burrows']
Gender = ['Male','Male','Female','Male']
Country = ['US','India','Qatar','Canada']

df2['Name'] = Name
df2['ID'] = ID
df2['Gender'] = Gender
df2['Country'] = Country

df3 = pd.concat([df1,df2],axis=0)

df4 = pd.concat([df1,df2],axis=1)

Create a new row to append
new_row = pd.Series([3001,'Steve Waugh','Male','Australia'], index=['ID', 'Name', 'Gender','Country'])

Append row
df5 = df3.append(new_row, ignore_index=True)

All Playlist of this youtube channel
====================================

1. Data Preprocessing in Machine Learning
https://www.youtube.com/playlist?list=PLE-8p-CwnFPuOjFcbnXLFvSQaHFK3ymUW

2. Confusion Matrix in Machine Learning, ML, AI
https://www.youtube.com/playlist?list=PLE-8p-CwnFPvXzvsEcgb0IZtNsw_0vUzr

3. Anaconda, Python Installation, Spyder, Jupyter Notebook, PyCharm, Graphviz
https://www.youtube.com/playlist?list=PLE-8p-CwnFPsBCsWwz_BvbZZHIVQ6wSZK

4. Cross Validation, Sampling, train test split in Machine Learning
https://www.youtube.com/playlist?list=PLE-8p-CwnFPsHtol5WXHhq_B3kQPggHH2

5. Drop and Delete Operations in Python Pandas
https://www.youtube.com/playlist?list=PLE-8p-CwnFPtvqVVK7QVFsMvDvp2YgCnR

6. Matrices and Vectors with python
https://www.youtube.com/playlist?list=PLE-8p-CwnFPsndwnZnL7nXW5mIrdRmgdg

7. Detect Outliers in Machine Learning
https://www.youtube.com/playlist?list=PLE-8p-CwnFPvyCX35yES5D9W7vThiUzwk

8. TimeSeries preprocessing in Machine Learning
https://www.youtube.com/playlist?list=PLE-8p-CwnFPv10bru3719xzDNIgbO6hXA

9. Handling Missing Values in Machine Learning
https://www.youtube.com/playlist?list=PLE-8p-CwnFPvOec0LZ40Bt8OQcbLFa236

10. Dummy Encoding Encoding in Machine Learning
https://www.youtube.com/playlist?list=PLE-8p-CwnFPvu7YriqMZsL9UDbqUUk90x

11. Data Visualisation with Python, Seaborn, Matplotlib
https://www.youtube.com/playlist?list=PLE-8p-CwnFPuYBYsmbfMjROOCzKjCwyMH

12. Feature Scaling in Machine Learning
https://www.youtube.com/playlist?list=PLE-8p-CwnFPtwpVV3FwzwYZYR5hT3i52G

13. Python 3 basics for Beginner
https://www.youtube.com/playlist?list=PLE-8p-CwnFPu-jseUMtc4i47jQZN4PNbf

14. Statistics with Python
https://www.youtube.com/playlist?list=PLE-8p-CwnFPta0COlxS6E5u14m5ouzbRU

15. Sklearn Scikit Learn Machine Learning
https://www.youtube.com/playlist?list=PLE-8p-CwnFPtAGb29r8F7up9ilZUXt3l1

16. Python Pandas Dataframe Operations
https://www.youtube.com/playlist?list=PLE-8p-CwnFPv_63lkT_Tztiwknv_zGTNy

17. Linear Regression, Supervised Machine Learning
https://www.youtube.com/playlist?list=PLE-8p-CwnFPslDi6sfFbFK4KXcVlLwaOM

18 Interiew Questions on Machine Learning and Data Science
https://www.youtube.com/playlist?list=PLE-8p-CwnFPt7VBhcnh82y0autSzuOrZp

19. Jupyter Notebook Operations
https://www.youtube.com/playlist?list=PLE-8p-CwnFPtqkFd67OZcoSv4BAI7ez5_