/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

5 votes125 views4 answers
How to input comma separated int values in python
Python
1 vote117 views1 answer
Camera lags when using with opencv
Python
1 vote130 views2 answers
C++ call python function
Python
0 vote212 views1 answer
Django never_cache example
Python Django
0 vote150 views1 answer
Class 10: Conditional Statements in Python [IF, ELIF, ELSE]
Python
0 vote141 views3 answers
Python remove accents
Python
0 vote227 views1 answer
Flask app with spark
Python
0 vote123 views1 answer
Import csv import re data = [] with open('customerData.csv') as csvfile: reader = csv.DictReader(csvfile) for row in reader: data.append(row) print(data[0]) print(data[1]["Name"]) print(data[2]["Spent Past 30 Days"])
Python
0 vote125 views1 answer
Transformer un dictionnaire en liste python
Python
0 vote153 views1 answer
Statement used to open a file in python
Python