/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

4 votes131 views1 answer
How many days until 2021
Python
0 vote150 views1 answer
Earthpy
Python
0 vote133 views1 answer
The module in NAME could not be imported: django.contrib.user_auth.password_validation.UserAttributeSimilarityValidator. Check your AUTH_PASSWORD_VALI
Python
12 votes126 views3 answers
Python check if input is a number
Python
0 vote121 views1 answer
Pandas array of dataframes
Python
5 votes155 views2 answers
Django admin password reset
Python Django
0 vote130 views1 answer
Aiml python install
Python
3 votes181 views1 answer
The authorization mechanism you have provided is not supported. Please use AWS4-HMAC-SHA256
Python
1 vote93 views2 answers
Fibonacci python
Python
0 vote160 views1 answer
Python create unreadable save file
Python