Channel: WiseOwlTutorials

Category: Education

Tags: pandaspythonfree tutorialonline trainingtutorialnumpyfree trainingwise owlprogrammingonline tutorial

Description: By Andy Brown Download files and exercises for this tutorial from 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 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: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! Visit 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!