/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

Python: select specific columns in a data frame

df = df[["Column_Name1", "Column_Name2"]]

Source: stackoverflow.com

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

Get particular columns from dataframe

x, y = df.iloc[:, [0]], df.iloc[:, [1]]

Source: stackoverflow.com

Similar codes

0 vote210 views1 answer
Sikuli guide text
Python
0 vote211 views1 answer
Python -m pip install -u pip
Python
1 vote190 views1 answer
What is the purpose of the judiciary
Python
2 votes218 views2 answers
Collections counter
Python
0 vote251 views1 answer
Truncatechars django
Python Django
0 vote259 views1 answer
Template tag django
Python Django
1 vote216 views1 answer
Cannot import name 'candlestick2_ohlc
Python
2 votes208 views1 answer
Get current time in python with strftime
Python
0 vote230 views1 answer
Initial TypedMultipleChoiceField django
Python Django
1 vote197 views1 answer
How to get pygame key
Python