Read and Write CSB using Panda Dataframe, by making CSV upper case column name

Feb 28, 2022    Janaki Mahapatra, Python 
import pandas as pd

try:	
	df = pd.read_csv('samplefile.csv')

	# return as (rows, column) tuple
	# print(df.shape)
	
	# All columns
	columns = df.columns	

	uppercaseColumns = [];

	for i in columns:
		uppercaseColumns.append(i.upper())

	df = df.values
	
	df2 = pd.DataFrame(df, columns=uppercaseColumns)

	df2.to_csv("new_uppercase_col.csv")

	print("success")

except:
	print("File is not valid")