Prerequisite: Creating views on Pandas DataFrame | Set – 1
Many times while doing data analysis we are dealing with a large data set has a lot of attributes. All the attributes are not necessarily equally important. As a result, we want to work with only a set of columns in the dataframe. For that purpose, let’s see how we can create views on the Dataframe and select only those columns that we need and leave the rest.
Given a Dataframe containing nba data, create views on it such that only desired columns are included.
Note : For link to the CSV file used in the code, click here
Solution #1: While reading the data from the csv file into Python, We can select all those columns that we want to read into the DataFrame.
Solution #2 : While reading the data from the csv file into Python, we can list all those columns that we do not want to read into the DataFrame. It is like dropping those columns.
Solution #3 : We can use the
difference() method to drop the columns that we do not need.
Now we will drop those columns which we do not need by using the
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course