Python Pandas Tutorial | Concatenate Pandas Dataframe - P12

Published: 18 December 2017
on channel: technologyCult

976

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
   • Data Preprocessing in Machine Learnin...

2. Confusion Matrix in Machine Learning, ML, AI
   • Confusion Matrix in Machine Learning,...

3. Anaconda, Python Installation, Spyder, Jupyter Notebook, PyCharm, Graphviz
   • Anaconda | Python Installation | Spyd...

4. Cross Validation, Sampling, train test split in Machine Learning
   • Cross Validation | Sampling | train t...

5. Drop and Delete Operations in Python Pandas
   • Drop and Delete Operations in Python ...

6. Matrices and Vectors with python
   • Matrices and Vectors with python

7. Detect Outliers in Machine Learning
   • Detect Outliers in Machine Learning

8. TimeSeries preprocessing in Machine Learning
   • TimeSeries preprocessing in Machine L...

9. Handling Missing Values in Machine Learning
   • Handling Missing Values in Machine Le...

10. Dummy Encoding Encoding in Machine Learning
   • Label Encoding, One hot Encoding, Dum...

11. Data Visualisation with Python, Seaborn, Matplotlib
   • Data Visualisation with Python, Matpl...

12. Feature Scaling in Machine Learning
   • Feature Scaling in Machine Learning

13. Python 3 basics for Beginner
   • Python | Python 3 Basics | Python for...

14. Statistics with Python
   • Statistics with Python

15. Sklearn Scikit Learn Machine Learning
   • Sklearn Scikit Learn Machine Learning

16. Python Pandas Dataframe Operations
   • Python Pandas Dataframe Operations

17. Linear Regression, Supervised Machine Learning
   • Linear Regression | Supervised Machin...

18 Interiew Questions on Machine Learning and Data Science
   • Interview Question for Machine Learni...

19. Jupyter Notebook Operations
   • Jupyter and Spyder Notebook Operation...

On this page of the site you can watch the video online Python Pandas Tutorial | Concatenate Pandas Dataframe - P12 with a duration of hours minute second in good quality, which was uploaded by the user technologyCult 18 December 2017, share the link with friends and acquaintances, this video has already been watched 976 times on youtube and it was liked by 15 viewers. Enjoy your viewing!