80/20 Pandas—Pandas for Data Science

Never miss a tutorial! Subscribe to the Project Data Science channel: https://bit.ly/3yTMdQV Go from zero to hero with our Data Science Specialization: https://courses.projectdatascience.co.... Or learn about all of data science in one blog post! https://www.projectdatascience.com/wh... ... The 20% of pandas that you need to know to get 80% of the value. Pandas is an extremely powerful library—it's basically like "Excel for Python", but more powerful and with the full power of Python behind it as well. But there's a lot of functionality in pandas that you're frankly never going to use. Most of the time, you're only going to need a handful of commands. This video is going to show you what those commands are. --- If you need to get your professional data science environment set up, here's a guide on exactly how to do that: https://www.projectdatascience.com/st.... (Or you can watch this video:    • Setting Up Your Python Data Science Enviro...  ) If you prefer a blog version of this pandas tutorial, you can find that here: https://www.projectdatascience.com/80... If you want a more in-depth pandas tutorial, we have that for you here:    • Pandas Mega-Tutorial - Learn one of Python...   And finally, here's a course that walks you through a whole machine learning / data science project from start to finish in Python: https://courses.projectdatascience.co... --- 00:00 Introduction 01:19 Launching Jupyter notebooks and creating a notebook 04:11 Primary pandas data structures - Series and DataFrame 12:57 Loading CSV data in pandas using read_csv 15:40 Looking at our data in pandas 19:47 Descriptive statistics in pandas 24:12 Looking at a single column in pandas 25:53 Plotting a histogram in pandas 27:23 Aggregation methods on a pandas Series - min, max, mean 28:47 Sorting a pandas DataFrame by a column 32:04 Filtering a pandas DataFrame by a column 37:51 Creating new columns in a pandas DataFrame 40:57 Using the map method on a Series 46:55 Follow along! Hands-on coding is the best way to learn! 47:29 Group by operations in pandas (similar to pivot tables) 55:01 Writing a pandas DataFrame to a CSV file using to_csv 56:49 Wrap-up and thank you!