Python csv to excel

Convert Excel to CSV using Python

import pandas as pd
data_xls = pd.read_excel('excelfile.xlsx', 'Sheet2', dtype=str, index_col=None)
data_xls.to_csv('csvfile.csv', encoding='utf-8', index=False)

Source: stackoverflow.com

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 csv to excel

with open('dict.csv', 'w') as csv_file:  
    writer = csv.writer(csv_file)
    for key, value in mydict.items():
       writer.writerow([key, value])

Similar codes

25 votes364 views5 answers
How to take the square root in python
Python
0 vote328 views1 answer
How to get the percentage accuracy of a model in python
Python
4 votes299 views1 answer
Alphabet position in python
Python
35 votes342 views4 answers
Python loop through directory
Python
3 votes375 views1 answer
How to find the number of times a number appears in python
Python
49 votes335 views6 answers
Plot using matplotlib
Python
14 votes342 views4 answers
Pandas get index of max value in column
Python
0 vote367 views1 answer
How to join basename and directory in python os
Python
15 votes362 views6 answers
Python last element of list
Python
0 vote329 views1 answer
Pandas concat / merge two dataframe within one dataframe
Python