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