Grouping Data in Python Using groupby for Sum, Mean, Min, Max, First, and Last on Pandas Dataframes In this episode, we’re going to look at how to do summary data by using a grouping method in Python, using Pandas. I’ll show you how to get the mean, sum, min, max, first, and last records for each group in your dataframe by using the .groupby method. One of the key skills in preparing data for analytics is the ability to efficiently group sets of records and apply calculations to them. For Python, using groupby in Pandas is one of the easiest and most efficient. Add this skill to your toolbox, and it will go a long way on your projects! Matplotlib line graph - How to create a line graph in python with matplotlib In this episode, we’re going to create some time series line graphs in Python, using matplotlib. This is an effective, easy visualization that can be done directly in matplotlib. We’ll connect to our database, extract a table for analysis, create some dataframes for analysis, and then plot them in a line graph. The data we’ll use is Cereal Yield in Kg per Hectare for three countries, from the Climate Change dataset provided by The World Bank. Related Videos: How to Install Pandas in Python https://www.youtube.com/watch?v=mlzWbimEwEw How to Filter and Sort a Pandas DataFrame https://www.youtube.com/watch?v=J622f4td668 How to Create Summary Statistics in Pandas https://www.youtube.com/watch?v=ceIQTbA0rbs How to Append Two Pandas DataFrames Together https://www.youtube.com/watch?v=KzK-yfkB4Fc How to Merge Pandas Dataframes in Python https://www.youtube.com/watch?v=IjGGx-xdMqw Excel to Access Using Python Pandas https://www.youtube.com/watch?v=7H4MVZBWFto How to Group Pandas Data with Totals You are watching this video now! CSV to Microsoft Access Using Python and Pandas https://www.youtube.com/watch?v=_fvCKUs4k30 Follow us on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering https://www.reddit.com/user/seamacke Data Project? Contact me today! https://www.youtube.com/watch?v=QuZTECujzTk