Breaking News: Grepper is joining You.com. Read the official announcement!

pandas load specific columns from file

Add Answer

Charles-Alexandre Roy answered on June 11, 2020 Popularity 7/10 Helpfulness 5/10

answer pandas load specific columns from file

related read specific columns from csv in python pandas

related load specific columns dataframe

pandas load specific columns from file

Comment

# Basic syntax:
import pandas as pd
df = pd.read_csv('file_with_header.tsv', usecols=['col_name1','col_name2'])

# Example usage:
# Say you have a TSV file with the following structure and only want to load the
# First_Name and Email fields:
ID	Date	First_Name	Last_Name	Email
2ICF7FPMPQ0585E0	1988-06-15	Rosenda	Mathis	leighamckeon31112@yahoo.com
VGPHBJKP1TX566LM	2008-08-27	Delicia	Wilder	demetrius-dickerson@gmail.com
C291NDCKKK9ZPUO4	2015-04-23	Rufina	Swanson	irina-mangum-geiger@coal.com
01R16K32IK9QUMLM	1985-01-13	John	Clarkson	maxfoley@made.yoshikawa.saitama.jp

df = pd.read_csv('file_with_header.tsv', usecols=['First_Name','Email'], sep='\t')
print(df)
  First_Name                               Email
0    Rosenda         leighamckeon31112@yahoo.com
1    Delicia       demetrius-dickerson@gmail.com
2     Rufina        irina-mangum-geiger@coal.com
3       John  maxfoley@made.yoshikawa.saitama.jp

Popularity 7/10 Helpfulness 5/10 Language python

Source: www.geeksforgeeks.org

Tags: file load pandas python

Link to this answer
Share Copy Link

Contributed on Jun 02 2023

Charles-Alexandre Roy

0 Answers Avg Quality 2/10

Closely Related Answers

read specific columns from csv in python pandas

Comment

import pandas as pd

df = pd.read_csv('some_data.csv', usecols = ['col1','col2'], low_memory = False)

Popularity 10/10 Helpfulness 9/10 Language python

Source: stackoverflow.com

Tags: csv

Link to this answer
Share Copy Link

Contributed on Jun 11 2020

Expensive Eagle

0 Answers Avg Quality 2/10

read specific columns from csv in python pandas

Comment

import pandas as pd
fields = ['star_name', 'ra']

df = pd.read_csv('data.csv', skipinitialspace=True, usecols=fields)
# See the keys
print df.keys()
# See content in 'star_name'
print df.star_name

Popularity 10/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: csv

Link to this answer
Share Copy Link

Contributed on Jun 11 2020

Expensive Eagle

0 Answers Avg Quality 2/10

read specific columns from csv in python pandas

Comment

import pandas as pd

# Specify the CSV file path
csv_file_path = 'path/to/your/csv/file.csv'

# Specify the columns to be read
columns_to_read = ['column1', 'column2', 'column3']

# Read the CSV file and extract only the specified columns
df = pd.read_csv(csv_file_path, usecols=columns_to_read)

# Print the resulting dataframe
print(df)

Popularity 5/10 Helpfulness 3/10 Language python

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

load specific columns dataframe

Comment

import pandas as pd
fields = ['star_name', 'ra']

df = pd.read_csv('data.csv', usecols=fields)

Popularity 9/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Jan 02 2022

Real Raccoon

0 Answers Avg Quality 2/10

pandas load specific columns from file

Contents

More Related Answers

pandas load specific columns from file

Closely Related Answers

read specific columns from csv in python pandas

read specific columns from csv in python pandas

read specific columns from csv in python pandas

load specific columns dataframe

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.