Search
 
SCRIPT & CODE EXAMPLE
 

PYTHON

convert excel file to csv with pandas

import pandas as pd
import os

df = pd.read_excel('Book1.xlsx', sheet_name='Sheet1')
current_working_directory = os.getcwd()
save_path = current_working_directory + 'file_name.csv'
df.to_csv(save_path)
Comment
PREVIOUS NEXT
Code Example
Python :: blender python select object by name 
Python :: python with file 
Python :: specify the number of decimals in a dataframe 
Python :: malier module python 
Python :: geometrical mean python 
Python :: python raise and exit 
Python :: how to select python 3 interpreter in linux 
Python :: python download youtube video 
Python :: check if string is empty python 
Python :: venv python 
Python :: tkinter menus 
Python :: python selenium get text of div 
Python :: print index of tuple python 
Python :: numpy array_equal 
Python :: check if date is valid python 
Python :: python iterate backwards through list 
Python :: How to Get the Difference Between Sets in Python 
Python :: ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1091) 
Python :: generate new secret key django 
Python :: removexa0 python 
Python :: how to print thgings in multiple linew in python 
Python :: numpy initialize 2d array 
Python :: remove specific word from string using python 
Python :: npr python 
Python :: create a new dataframe from existing dataframe pandas 
Python :: random question generator python 
Python :: best pyqt5 book 
Python :: how to clear the screen of the terminal using python os 
Python :: pip install for python 2 and python3 
Python :: Python Requests Library Get Method 
ADD CONTENT
Topic
Content
Source link
Name
8+9 =