5 Minute Python Scripts - Automate Multiple Sheet Excel Reporting - Full Code Along Walkthrough
** Five Minute Python Tutorial **
Automate creating excel reports from multiple excels sheets using Python
Uses xlrd is read in excel sheets, get their data, and perform data analytics.
Kite helps fund the channel, thanks for checking them out and supporting me --
⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing. https://www.kite.com/get-kite/?utm_me...
Ideas with this script:
Connect to Python Time and run at certain intervals throughout a day with changing data sets
Create custom reports that you can connect to any excel sheet using matplotlib
& Plenty More
Code for the for loop used in the video:
i =0
total =0
for row in range(first_sheet.nrows):
if str(first_sheet.cell(row,1).value) == "Key Lime":
i = i +1
total = total + (first_sheet.cell(row,2).value)
else:
pass
for row in range(second_sheet.nrows):
if str(first_sheet.cell(row,1).value) == "Key Lime":
i = i +1
total = total + (second_sheet.cell(row,2).value)
else:
pass
print(i)
print(total)
print(total/i)
Let me know in the comments below if you would like a certain Python tutorial. Thanks!!
