import pandas as pd

df = pd.read_csv('/content/clean_agri_ds.csv')

df.head(1)

	Unnamed: 0	State_Name	District_Name	Crop_Year	Season	Crop	Area	Production	Len State	Len Dist	Len Season	Len Crop
0	4351	Andhra Pradesh	KRISHNA	2005	Kharif	Moong(Green Gram)	12334.0	9991.0	14	7	6	17

reqd_list = ['Season', 'District_Name', 'Area', 'Production', 'Crop_Year' ]

input_list = []
input_list = df.columns

input_list

Index(['Unnamed: 0', 'State_Name', 'District_Name', 'Crop_Year', 'Season',
       'Crop', 'Area', 'Production', 'Len State', 'Len Dist', 'Len Season',
       'Len Crop'],
      dtype='object')

reqd_list[2]

'Season'

hasCols = []
for item in reqd_list:
    if item in input_list:
        print(" order =>", item)
        hasCols.append(item)
    else:
        print("not in order =>", item)
#        df.drop[item, inplace = True]
print (hasCols)

 order => Season
 order => District_Name
 order => Area
 order => Production
 order => Crop_Year
['Season', 'District_Name', 'Area', 'Production', 'Crop_Year']

hasCols

['State_Name', 'Crop_Year', 'Season', 'Crop_Year']

ndf = df[['Season', 'Crop', 'State_Name', 'Crop_Year']]

ndf.head(2)

	Season	Crop	State_Name	Crop_Year
0	Kharif	Moong(Green Gram)	Andhra Pradesh	2005
1	Kharif	Papaya	Assam	2013

new = df.filter(hasCols, axis=1)

new.head(2)

	Season	Crop	State_Name	Crop_Year
0	Kharif	Moong(Green Gram)	Andhra Pradesh	2005
1	Kharif	Papaya	Assam	2013

all(i == j for i, j in zip(reqd_list, input_list))

False