Convert CSV to Excel using Pandas in Python
Last Updated :
22 Feb, 2022
Pandas can read, filter, and re-arrange small and large datasets and output them in a range of formats including Excel. In this article, we will be dealing with the conversion of .csv file into excel (.xlsx).
Pandas provide the ExcelWriter class for writing data frame objects to excel sheets.
Syntax:
final = pd.ExcelWriter('GFG.xlsx')
Example:
Sample CSV File:
Python3
import pandas as pd
df_new = pd.read_csv( 'Names.csv' )
GFG = pd.ExcelWriter( 'Names.xlsx' )
df_new.to_excel(GFG, index = False )
GFG.save()
|
Output:
Method 2:
The read_* functions are used to read data to pandas, the to_* methods are used to store data. The to_excel() method stores the data as an excel file. In the example here, the sheet_name is named passengers instead of the default Sheet1. By setting index=False the row index labels are not saved in the spreadsheet.
Python3
import pandas as pd
df = pd.read_csv( "./weather_data.csv" )
df.to_excel( "weather.xlsx" , sheet_name = "Testing" , index = False )
|
Share your thoughts in the comments
Please Login to comment...