How To Automate Excel Using Python | Combine Files & Create Charts ๐Ÿค“


    ๐Ÿš€ 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]:

    Pandas Cheat Sheet:

    ๐—–๐—ข๐—ก๐—ก๐—˜๐—–๐—ง ๐—ช๐—œ๐—ง๐—› ๐— ๐—˜:
    ๐ŸŒŽ Website:
    ๐Ÿ“ GitHub:
    โญ Discord:
    โ–ถ๏ธ Subscribe:

    ๐ŸŽ‰ ๐—™๐—ฅ๐—˜๐—˜ ๐—˜๐˜…๐—ฐ๐—ฒ๐—น ๐—”๐—ฑ๐—ฑ-๐—ถ๐—ป ๐˜๐—ผ ๐—ฏ๐—ผ๐—ผ๐˜€๐˜ ๐˜†๐—ผ๐˜‚๐—ฟ ๐—ฝ๐—ฟ๐—ผ๐—ฑ๐˜‚๐—ฐ๐˜๐—ถ๐˜ƒ๐—ถ๐˜๐˜†
    Get it here:

    ๐Ÿ“š ๐—ฅ๐—ฒ๐˜€๐—ผ๐˜‚๐—ฟ๐—ฐ๐—ฒ๐˜€ ๐—ณ๐—ผ๐—ฟ ๐—น๐—ฒ๐—ฎ๐—ฟ๐—ป๐—ถ๐—ป๐—ด ๐—ฉ๐—•๐—” & ๐—ฃ๐˜†๐˜๐—ต๐—ผ๐—ป
    Check out my recommendations:

    โ˜• ๐—•๐˜‚๐˜† ๐—บ๐—ฒ ๐—ฎ ๐—ฐ๐—ผ๐—ณ๐—ณ๐—ฒ๐—ฒโ“
    If you want to support this channel, you can buy me a coffee here:


    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


    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