/Python/Python extract specific columns from pandas dataframe

Python extract specific columns from pandas dataframe

# Basic syntax:
new_dataframe = dataframe.filter(['col_name_1', 'col_name_2'])
# Where the new_dataframe will only have the column names specified

# Note, use df.filter(['names', ... ], axis=0] to select rows

Source: pandas.pydata.org

Extract one column from dataframe python

import pandas as pd

input_file = "C:\\....\\consumer_complaints.csv"
dataset = pd.read_csv(input_file)
df = pd.DataFrame(dataset)
cols = [1,2,3,4]
df = df[df.columns[cols]]

Source: stackoverflow.com

Similar codes

2 votes264 views1 answer
Json dumps datetime
Python
1 vote196 views1 answer
How call module in the same directory
Python
0 vote194 views1 answer
Column names reading csv file python
Python
9 votes248 views1 answer
Python remove duplicates from a list
Python
33 votes194 views6 answers
Bs4 python
Python
26 votes178 views1 answer
Dictionary from two lists
Python
7 votes202 views1 answer
Python marker size
Python
0 vote204 views1 answer
Convert torch.nn.Embedding layer to numpy array
Python
0 vote200 views2 answers
Pandas series to numpy array
Python
0 vote179 views1 answer
Add field placeholder layout crispy modelform
Python