How To Automate Excel Using Python | Combine Files & Create Charts 🤓

    1046
    25



    🚀 In this tutorial, I will show you how you can automate your excel tasks using python.
    In particular, I am going to show you how you can combine excel files & create charts out of them.

    ✅ Chapters:
    0:00 Intro & Overview
    2:27 Python Code
    10:20 Outro

    Python Code and files used in the tutorial [GitHub]:
    👉 https://github.com/Sven-Bo/combine-excel-files-with-python

    Pandas Cheat Sheet:
    👉 https://bit.ly/33K8DXp

    ◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
    𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘:
    🌎 Website: https://pythonandvba.com
    📝 GitHub: https://github.com/Sven-Bo
    ⭐ Discord: https://pythonandvba.com/discord
    ▶️ Subscribe: https://youtube.com/c/CodingIsFun?sub_confirmation=1

    🎉 𝗙𝗥𝗘𝗘 𝗘𝘅𝗰𝗲𝗹 𝗔𝗱𝗱-𝗶𝗻 𝘁𝗼 𝗯𝗼𝗼𝘀𝘁 𝘆𝗼𝘂𝗿 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆
    Get it here: https://pythonandvba.com/mytoolbelt

    📚 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗩𝗕𝗔 & 𝗣𝘆𝘁𝗵𝗼𝗻
    Check out my recommendations: https://pythonandvba.com/resources

    ☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲❓
    If you want to support this channel, you can buy me a coffee here:
    https://pythonandvba.com/coffee-donation

    source

    Previous articleBusiness Analyst Full Course In 2 Hours | Business Analyst Training For Beginners | Simplilearn
    Next articleAWS Boto3 Python Crash Course with AWS S3 | Getting Started with Boto3 and AWS S3

    25 COMMENTS

    1. Thanks for the amazing work.
      Haven't gotten a reply yet though, what if there's a different folder directory, the both have same column name but different content, how do we merge?

      For example, there's folder A that contains January to March sales and folder B has January to March sales also but different sales input. How do we merge per column, merge folder then have the January in one xlsx file, February in one and the whole of march in one xlsx also