Answers for "how to read csv file as a excel sheet in python"

how to convert csv to excel in python

import pandas as pd

data = pd.read_csv("k.csv")

data.to_excel("new_file.xlsx", index=None, header=True)

python openpyxl csv to excel

import pandas as pd

read_file = pd.read_csv (r'Path where the CSV file is storedFile name.csv')
read_file.to_excel (r'Path to store the Excel fileFile name.xlsx', index = None, header=True)