By Andy Brown

Download files and exercises for this tutorial from https://www.wiseowl.co.uk/python/videos/python-programming/pandas/

This tutorial explains what pandas is and does, including creating dataframes, importing data into them from CSV files, Excel workbooks and SQL Server tables, indexing dataframes, showing statistics and much more besides!

Chapters
00:00:00 Topic list
00:01:39 What panda is, and whether it's for you
00:04:50 Installing pandas
00:06:06 Installing dataframes and series
00:10:03 Showing dataframe information
00:15:00 Reading from/writing to CSV files
00:18:46 Reading from/writing to Excel workbooks
00:24:38 Reading from/writing to SQL Server tables
00:32:33 Slicing and indexing dataframes
00:37:29 Sorting and filtering
00:42:22 Showing statistics, including grouping
00:51:56 Creating new columns
00:58:57 Renaming columns, joining tables and removing duplicates
01:08:37 Using matplotlib

Python playlist https://youtube.com/playlist?list=PLNIs-AWhQzckGrdnwITFlXGqiXTCAhWWi

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!