DataFrame Manipulation using Pandas — Part I

DataFrame Manipulation using Pandas — Part I

In this blog, we'll learn Learn how to create DataFrames, configure & reshape them using some of the most common methods/functions from Pandas

This blog follows a first one that I named “Basic DataFrame Manipulation using Pandas” which I published a few months ago, where I tried to give some tips and show short workflows that I use on a regular basis. Most of it, if not all of the content was for beginners, so I decided to do a second one with slightly more complex functions and methods which I broke down into two parts, not to make a super long blog tedious to follow.

Once again, I will try to do this as an exercise starting from creating my own DataFrame (df) and then playing with it as much as I can trying to keep it to maximum an intermediate level. Later on, and after parts I and II of this blog are published, I will focus on writing an advance one following a project with real data.

The content that I will cover is the following:

  1. Creating a DataFrame from a dictionary
  2. Configurations and Settings
  3. Combining DataFrames
  4. Reshaping your dataFrame
  5. Using the Datetime module
  6. Using the groupby() method/function
  7. Slicing using .loc and .iloc

If by the time I finish with the second part I find that the level is not high enough, then I will modify this content and edit it in this blog as well so that they are both coherent.

Because I am a big basketball fan, I will use once again NBA data, but this time I will take stats from the 2019–2020 recently finished season and I will use the top 25 scorers. With that said, let’s jump straight into the content.

pandas towards-data-science data-science python dataframes

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Data Science With Python Training | Python Data Science Course | Intellipaat

🔵 Intellipaat Data Science with Python course: this Data Science With Python Training video, you...

How To Build A Data Science Career In 2021

In Conversation With Dr Suman Sanyal, NIIT University,he shares his insights on how universities can contribute to this highly promising sector and what aspirants can do to build a successful data science career.

Data Science with Python Certification Training in Chennai

Enroll in our Data Science with Python training in Chennai. Best Data Science with Python Training courses in Chennai for 100% Job Placements Support.

Python for Data Science | Data Science With Python | Python Data Science Tutorial

🔥Intellipaat Python for Data Science Course: this python for data science video you will learn e...

Applied Data Science with Python Certification Training Course -IgmGuru

Master Applied Data Science with Python and get noticed by the top Hiring Companies with IgmGuru's Data Science with Python Certification Program. Enroll Now