Read a Subset of Columns from a CSV into a Pandas DataFrame

Python
Import and Export

To read only a subset of columns into a Pandas dataframe from a csv file, pass a list of columns to the "usecols" parameter when calling read_csv.

In the example below, only the columns order_number, product and sale_price are read into the dataframe.

 1|  import pandas as pd
 2|  
 3|  columns = ['order_number', 'product', 'sale_price']
 4|  df = pd.read_csv('sales.csv', usecols=columns)
DETRO
1 Upvote
Tags: Csv | Read_csv
Did you find this snippet useful?

Sign up to bookmark this in your snippet library

Scrape Reddit Posts Using PMAW & Python
Python
Import and Export

Scraping | Reddit | Pmaw

2
Creating a Pandas DataFrame from a Python Generator
Python
Import and Export

Pandas | Dataframe | Generator

2
Import Tweet Data Using Twitter API & Tweepy
Python
Import and Export

Tweepy | Twitter | API

2
Import from SQL Server into Pandas Dataframe
Python
Import and Export

Pandas | Import | Sql

2
Reading CSV Files from Amazon S3 into Pandas Dataframes
Python
Import and Export

Pandas | Python | S3

1
Sklearn Iris Dataset - Load The Iris Dataset & Split Into Features & Target
Python
Import and Export

Sklearn | Iris

1
Using Selectors in Beautiful Soup to Scrape Using Classes & IDs
Python
Import and Export

Beautiful soup | Scarping

1
Get The Text Within a Tag Using Beautiful Soup
Python
Import and Export

Scraping | Beautiful soup

1
Get An Inner Tag Using Beautiful Soup
Python
Import and Export

Scraping | Beautiful soup

1
Find the Nth Tag On a WebPage with Beautiful Soup
Python
Import and Export

Scraping | Beautiful soup

1