Excel Report Automation with Python - Easy Multiple Excel Sheet Reports - Python Code Walkthrough

In Excel Report Automation with Python – Easy Multiple Excel Sheet Reports – Python Code Walkthrough
we will show how to generate automated reports from data in Excel to Excel using Python.

We will cover the following
馃憠 How to import data from Excel to Python Pandas
馃憠 How to group data simply by identifiers like a Sales rep with Python Pandas
馃憠 How to group data in months with Python Pandas
馃憠 How to change the date to a Month in written language
馃憠 How to export the grouped data
馃憠 How to make charts in Excel from Python export

Want to code along?
馃憠 Check out the link to tutorial 馃憠 https://www.learnpythonwithrune.org/how-to-create-excel-report-automation-with-python/
馃憠 Find the Excel sheet and JuPyter notebook in download
馃憠 Want JuPyter notebook – it is FREE (download Anaconda)
馃憠 Download Anaconda 馃憠 https://www.anaconda.com/products/individual

You liked this video and want to learn more?
馃憠 Like + Subscribe + Notify
馃憠 Share
馃憠 Comment with suggestions

/// STAY CONNECTED – You can reach me here:
馃憠 Facebook: https://www.facebook.com/learnpythonwithrune
馃憠 Twitter: https://twitter.com/PythonWithRune
馃憠 Blog: http://learnpythonwithrune.org
馃憠 Online courses: https://www.learnpythonwithrune.org/my-online-courses/


14 thoughts on “Excel Report Automation with Python – Easy Multiple Excel Sheet Reports – Python Code Walkthrough”
  1. Thank you for the video! It was interesting, though I ran into a problem or two. I was using VS Code, and instead of using xlsxwriter it tried to use openpyxl, that had no add_chart method, so I had to implicitly import it (maybe this comment will be useful for someone). Not to annoy anyone, but is not it better to use 'with' statement, instead of closing writer manually (in case program runs into some errors before)? Like with pd.ExcelWriter(filename) as writer: …

  2. Hey thanks Rune; very nice video, could u plz make a video where we have lots of calculation in excel like getting the difference, calculating percentage , pivot table,etc. Which can be automated using python. Would like to hear from u soon.

  3. Help me bro!!!
    I have one error.
    FileNotFoundError: [Errno 2] No such file or directory : ' billing. xlsx'

  4. Hey Rune,
    First of all, thanks for your wonderful video which is really helpful. I have a quick query that how I can open an excel file after using the ExcelWriter function I'm unable to open the report could you please help me out with this. Thank you.

  5. Hey Rune, thanks for your video! I鈥檓 very interested in Python (although I don鈥檛 know a single thing about it), but the issue is the majority of videos such as this one looks a little bit easy to be done through excel (filter, sorting & pivot tables)! I鈥檒l will be wasting time writing formulas. This is my opinion that I would love to hear back from you as you鈥檙e expert and definitely have worked on both, so correct me if I鈥檓 wrong and thanks again

Leave a Reply

Your email address will not be published.

Captcha loading...