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

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

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

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

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

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 Learning  

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

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

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

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

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

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 Machine Lea...  

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

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