Pandas Crosstab Tutorial | Python Pandas Tutorial #7 | Aggfunc, Margins, Normalize Data
Pandas crosstabs (cross tabulations) are frequency distributions of two or more variables. Learn how to create crosstabs with Python and Pandas, including how to normalize your data to calculate row and column percentages. Download the dataset here: https://github.com/datagy/mediumdata/raw/master/sample_pivot.xlsx Read the full written tutorial here: https://datagy.io/pandas-crosstab/ See the rest of the playlist here: https://www.youtube.com/playlist?list=PLYt6YwKmonu0x8oI_tLT_vaOFzRU64ptK Crosstabs are also known as contingency tables. 0:00 Introduction 0:26 Differences to Pandas Pivot Table Function 1:50 Pandas Crosstab 2:59 Pandas Crosstab Aggfunc 4:15 Changing Pandas Crosstab Names (colnames, rownames ) 5:07 Multiple Indexes Pandas Crosstabs 7:03 Multiple Columns in Pandas Crosstabs 7:55 Changing Multiple Row and Column Names 8:49 Pandas Crosstab Normalize Results 10:21 Pandas Crosstab Margins / Totals 11:53 Challenge and Conclusion Learn Python programming the right way! ---------------------------------------------------------- ✅ Check out my eBook to get started with Python for Data Science: https://gumroad.com/l/introtopythonfo... ✅ Follow me on other platforms: Website: https://datagy.io Twitter: https://twitter.com/DatagyIo Mailing List: https://mailchi.mp/f6a58f2d73d0/datag... (and get a FREE Pandas tip and tricks book and a FREE Guide to SQL)
Pandas crosstabs (cross tabulations) are frequency distributions of two or more variables. Learn how to create crosstabs with Python and Pandas, including how to normalize your data to calculate row and column percentages. Download the dataset here: https://github.com/datagy/mediumdata/raw/master/sample_pivot.xlsx Read the full written tutorial here: https://datagy.io/pandas-crosstab/ See the rest of the playlist here: https://www.youtube.com/playlist?list=PLYt6YwKmonu0x8oI_tLT_vaOFzRU64ptK Crosstabs are also known as contingency tables. 0:00 Introduction 0:26 Differences to Pandas Pivot Table Function 1:50 Pandas Crosstab 2:59 Pandas Crosstab Aggfunc 4:15 Changing Pandas Crosstab Names (colnames, rownames ) 5:07 Multiple Indexes Pandas Crosstabs 7:03 Multiple Columns in Pandas Crosstabs 7:55 Changing Multiple Row and Column Names 8:49 Pandas Crosstab Normalize Results 10:21 Pandas Crosstab Margins / Totals 11:53 Challenge and Conclusion Learn Python programming the right way! ---------------------------------------------------------- ✅ Check out my eBook to get started with Python for Data Science: https://gumroad.com/l/introtopythonfo... ✅ Follow me on other platforms: Website: https://datagy.io Twitter: https://twitter.com/DatagyIo Mailing List: https://mailchi.mp/f6a58f2d73d0/datag... (and get a FREE Pandas tip and tricks book and a FREE Guide to SQL)