Python Pandas Drop Dataframe
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
df = pd.read_csv('C:LoadProfilesCSVWillBaySchl 2013_2014 KW.csv')
print(df)
This will return the head/tail and:[34944 rows x 3 columns]
pos0 = 0
pos1 = 1
pos2 = 2
colname = df.columns[pos0]
print(colname)
This will return: Meter ID (I want to drop this column/dataframe)
colname = df.columns[pos1]
print(colname)
This will return: Date / Time (I want this to be the pd data frame index)
colname = df.columns[pos2]
print(colname)
This will return: KW(ch: 1 set:0) (This is the data that I want to rename "kW" and do some wrangling...)
If I try this code below:
df = pd.DataFrame.drop(['Meter ID'], axis=1)
print(df)
Python will return the error:TypeError: drop() missing 1 required positional argument: 'labels'
If I try this code below:
df = pd.DataFrame.drop(columns=['Meter ID'])
print(df)
Python will return the error: TypeError: drop() got an unexpected keyword argument 'columns'
Any help is greatly appreciated...
To solve “drop() got an unexpected keyword argument 'columns' “ error you are required to delete the single column, we can use:
df = pd.DataFrame.drop('Meter ID', axis=1)
For deleting more than 1 column:
df = pd.DataFrame.drop(['Meter ID', 'abc'], axis=1)
And for deleting the entire df you can use:
del df
or
df = None