PYTHON

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 

Extract column from a pandas dataframe

input_file = "C:....consumer_complaints.csv"
dataset = pd.read_csv(input_file)
df = pd.DataFrame(dataset)
new_dataframe = df.filter(['col_name_1', 'col_name_2'])

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]]

extract a column from a dataframe in python

data_frame["Column_Name"]