/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

3 votes135 views2 answers
Date object into date format python
Python
0 vote170 views1 answer
Setting python2 in the path for npm install
Python
1 vote102 views1 answer
[Solved] ValueError: If using all scalar values, you must pass an index
Python
8 votes97 views1 answer
How to check if string exists in array pytohn
Python
0 vote235 views1 answer
Free the Bunny Prisoners
Python
0 vote128 views1 answer
How to convert word to number in python pandas
Python
1 vote164 views2 answers
Python spread operator
Python
0 vote142 views1 answer
Python string: immutable string
Python
1 vote204 views1 answer
Jun 12, 2007 hoteis othon
Python
0 vote142 views1 answer
Pandas create average per group
Python