PinnedDean McGrathinTowards Data SciencePython Pandas Iterating a DataFrameLearn the different ways that you can iterate a Pandas DataFrame using Python·4 min read·Oct 8, 2020--1--1
Dean McGrathinTowards Data SciencePython Pandas Reading a CSVLearn how to read a CSV file and create a Pandas DataFrame·9 min read·Feb 2, 2021----
Dean McGrathinTowards Data ScienceUnpivoting a Pandas DataFrameHow to massage a Pandas DataFrame into the shape you need·3 min read·Jan 29, 2021--1--1
Dean McGrathinTowards Data SciencePivoting a Pandas DataFrameTwo lines of code that saved me hours of work·3 min read·Jan 24, 2021--3--3
Dean McGrathinTowards Data ScienceHow to Build a Multi Tabbed Excel File Using PandasLearn how to output multiple Pandas DataFrames to an Excel·3 min read·Nov 30, 2020--1--1
Dean McGrathinTowards Data ScienceHow to Drop Duplicates in PandasLearn how to drop duplicates from a Pandas DataFrame to improve your data quality·3 min read·Nov 25, 2020--1--1
Dean McGrathinTowards Data ScienceHow to Combine Python, Pandas & XlsxWriterLearn how to output a Pandas DataFrame to Excel with formatting using XlsxWriter·3 min read·Nov 23, 2020--2--2
Dean McGrathinTowards Data ScienceData Analytics — Time Saving TipsTips and tricks you can use to save time as a Data Analyst and increase your productivity.·4 min read·Nov 20, 2020----
Dean McGrathinTowards Data SciencePython Pandas Merging DataFramesA quick how-to guide for merging Pandas DataFrames in Python·5 min read·Oct 12, 2020----
Dean McGrathinTowards Data SciencePandas Series & DataFrame ExplainedA comprehensive guide to understanding Pandas Series and DataFrame data structures·4 min read·Oct 9, 2020--1--1