Pandas Crosstab for Data Analysis and Visualisation - P35

Опубликовано: 10 Октябрь 2024
на канале: technologyCult

821

Pandas Crosstab for Data Analysis and Visualisation - P35

Topic to be covered - Crosstab in python

Code Start Here
=============

import pandas as pd

df = pd.read_csv('train.csv')

crosstab1 = pd.crosstab(df['Pclass'],df['Sex'])

crosstab1.plot(kind='barh',stacked=True,color=['yellow','purple'],grid=False)

crosstab2 = pd.crosstab(df['Pclass'],df['Survived'])

crosstab2.plot(kind='barh',stacked=True,color=['yellow','purple'],grid=False)
-----------------------------------------------

df['Title'] = df['Name'].str.extract('([A-Za-z]+)\.',expand=True)

df['Title'] = df['Title'].replace(['Lady','Countess','Capt','Dr','Don','Rev','Sir',
'Jonkheer','Dona','Col','Major'],'VeryRare')

df['Title'] = df['Title'].replace('Mme','Mrs')
df['Title'] = df['Title'].replace('Mlle','Miss')
df['Title'] = df['Title'].replace('Ms','Miss')

crosstab3 = pd.crosstab(df['Title'],df['Survived'])

crosstab3.plot(kind='barh',stacked=True,color=['red','green'],grid=False)

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
   • Interview Question for Machine Learni...

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