Pandas Implementation
Let’s create a simple dataset to demonstrate the renaming process:
Python3
# Import the csv moduleimport csv# Define the data as a list of dictionariesdata = [ {"Name": "Alice", "Age": 12, "Gender": "F", "Grade": "A"}, {"Name": "Bob", "Age": 13, "Gender": "M", "Grade": "B"}, {"Name": "Charlie", "Age": 14, "Gender": "M", "Grade": "C"}, {"Name": "David", "Age": 12, "Gender": "M", "Grade": "A"}, {"Name": "Eve", "Age": 13, "Gender": "F", "Grade": "B"}]# Open a new csv file for writingwith open("data.csv", "w") as file: # Create a csv writer object writer = csv.DictWriter(file, fieldnames=["Name", "Age", "Gender", "Grade"]) # Write the header row writer.writeheader() # Write the data rows writer.writerows(data)# Close the filefile.close() |
Rename column name with an index number of the CSV file in Pandas
In this blog post, we will learn how to rename the column name with an index number of the CSV file in Pandas.
Contact Us