Creating views on Pandas DataFrame | Set – 2

Last Updated : 26 Jan, 2019

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.

   # importing pandas as pd 
import pandas as pd 
  
# list of columns that we want to 
# read into the DataFrame 
use_cols =['Name', 'Number', 'College'] 
  
# Reading the csv file 
df = pd.read_csv('nba.csv', usecols = lambda x : x in use_cols, 
                                             index_col = False) 
  
# Print the dataframe 
print(df) 
 
  

Output :

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.

   # importing pandas as pd 
import pandas as pd 
  
# list of columns that we do not want 
# to read into the DataFrame 
skip_cols =['Name', 'Number', 'College'] 
  
# Reading the csv file 
df = pd.read_csv('nba.csv', usecols = lambda x : x not in skip_cols, 
                                                  index_col = False) 
  
# Print the dataframe 
print(df) 
 
  

Output :

Solution #3 : We can use the difference() method to drop the columns that we do not need.

   # importing pandas as pd 
import pandas as pd 
  
# Reading the csv file 
df = pd.read_csv("nba.csv") 
  
# Print the dataframe 
print(df) 
 
  

Output :

Now we will drop those columns which we do not need by using the difference() method.

   # Drop the listed columns 
df_view = df[df.columns.difference(['Position', 'Age', 'Salary'])] 
  
# Print the new DataFrame 
print(df_view)

Output :

Adding New Variable to Pandas DataFrame

Shubham__Ranjan

Improve

Article Tags :

Practice Tags :

python

Similar Reads

Creating views on Pandas DataFrame

Many times while doing data analysis we are dealing with a large data set, having 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 Datafr

2 min read

Creating a Pandas DataFrame

Pandas DataFrame comes is a powerful tool that allows us to store and manipulate data in a structured way, similar to an Excel spreadsheet or a SQL table. A DataFrame is similar to a table with rows and columns. It helps in handling large amounts of data, performing calculations, filtering informati

3 min read

Adding New Variable to Pandas DataFrame

In this article let's learn how to add a new variable to pandas DataFrame using the assign() function and square brackets. Pandas is a Python package that offers various data structures and operations for manipulating numerical data and time series. It is mainly popular for importing and analyzing d

3 min read

Different ways to create Pandas Dataframe

It is the most commonly used Pandas object. The pd.DataFrame() function is used to create a DataFrame in Pandas. There are several ways to create a Pandas Dataframe in Python. Example: Creating a DataFrame from a Dictionary [GFGTABS] Python import pandas as pd # initialize data of lists. data = {

7 min read

How to Set Cell Value in Pandas DataFrame?

In this article, we will discuss how to set cell values in Pandas DataFrame in Python. Method 1: Set value for a particular cell in pandas using dataframe.at This method is used to set the value of an existing value or set a new record. [GFGTABS] Python3 # import pandas module import pandas as pd #

2 min read

Creating a Pandas Series from Dictionary

A Pandas Series is a one-dimensional labeled array capable of holding any data type (integers, strings, floating point numbers, Python objects, etc.). It has to be remembered that, unlike Python lists, a Series will always contain data of the same type. Letâ€™s see how to create a Pandas Series from P

2 min read

Creating Pandas dataframe using list of lists

In this article, we will explore the Creating Pandas data frame using a list of lists. A Pandas DataFrame is a versatile 2-dimensional labeled data structure with columns that can contain different data types. It is widely utilized as one of the most common objects in the Pandas library. There are v

4 min read

Create a list from rows in Pandas DataFrame | Set 2

In an earlier post, we had discussed some approaches to extract the rows of the dataframe as a Python's list. In this post, we will see some more methods to achieve that goal. Note : For link to the CSV file used in the code, click here. Solution #1: In order to access the data of each row of the Pa

2 min read

DataFrame vs Series in Pandas

Pandas is a widely-used Python library for data analysis that provides two essential data structures: Series and DataFrame. These structures are potent tools for handling and examining data, but they have different features and applications. In this article, we will explore the differences between S

8 min read

Creating a Pandas Series

A Pandas Series is like a single column of data in a spreadsheet. It is a one-dimensional array that can hold many types of data such as numbers, words or even other Python objects. Each value in a Series is associated with an index, which makes data retrieval and manipulation easy. This article exp

3 min read