Batch rename and xls to csv

By - 

'''
#Remove spaces from filename
import os
path  = 'C:\\Users\\gaura\\Downloads\\estmst' #os.getcwd()
filenames = os.listdir()
for filename in filenames:
    os.rename(os.path.join(path, filename), os.path.join(path, filename.replace(' ', '-')))
    '''


import os, pandas as pd
path  = 'C:\\Users\\gaura\\Downloads\\estmst'

for filename in os.listdir(path):
    data_xls = pd.read_excel(filename, 'Main Dashboard Excel', index_col=None)
    data_xls.to_csv(filename+'.csv', encoding='utf-8', index=False)

Comments

Post a Comment

Popular posts from this blog

Tumblr posts about sexplanation, DoeEyes and Dr. Lindsay Doe

By -
Image
I just came to know about youtube channels:DoeEyes and sexplanation by Dr. Lindsay Doe I thought of reviewing it myself but my words were not doing justice. Instead, I decided to collect different posts from tumblr. Youtube links:  DoeEyes , sexplanations Tumblr: tumblingdoe.tumblr.com/ Brighten your day up and squee for 10 seconds Okay I thought I wasn’t really going to be into watching the sexplanations channel just because it was a bunch of medical stuff but Lindsey, the host, is so fucking hilarious and adorable. Great channel to check out guys, you learn a lot and it’s just enjoyable. Many thanks for Hank, John, and the nerdfighteria census for letting me know about this great channel I missed. This woman makes me happy. I really love Dr. Doe. Sexplanations has become one of my favorite YouTube channels to watch; she’s just so cute. I love youtube channel sexplanations. Dr. Lindsey Doe is my favorite sex educator on the internet. - This is a prime example of
Read more

बैगन

By -
कुछ फैला हुआ सा डर है, कुछ छाई है इर्ष्या सी, जीत से नहीं, खुश होते - हार से दूसरों की, ना जाने क्या चाहते हैं, थाली का बैगन हो जैसे, आँखें मूंदे भागते जाते हैं।
Read more

Type of Common Charts used in visualization

By -
 Type of Common Charts used in Visualization Horizontal Bar Vertical Bar/Column Line Area Scatter Pie Pictograph Bubble Chart Guage Chart Stacked Venn Map(area) Map(Point) Box Plot Vertical Stacked Bar Side by Side bar HeatMap Radar/Spider Chart Tree Maps Circle Views/side by side Circles Feature Table A design doesn't just have information but also an intention.                                                                            -Someone famous   In my opinion, the field of Magic, perception, Cognitive Science, Behavioural Economics, Art of Persuation, User Interface Design, User Experience, Data Science, Data Visualisation, Color Theory etc. are up to some percent are related to each other  
Read more