There’s a lot of pain points in Excel that make it a tool that’s cumbersome and repetitive for data manipulation. But did you know that you can also use Python to automate repetitive tasks in Excel? In this video, I will be sharing my favourite ways to automate Microsoft Excel using Python. In particular, we will be using the open-source tools: Pandas, xlwings & plotly. After this video, you will be able to create a custom Python script that allows you to combine excel files & create charts out of them.
???? ????????????????????????????????????:
Download the Jupyter Notebook here: https://github.com/Sven-Bo/automate-excel-with-python
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
???????????????????????????? ???????????????? ????????:
???? 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://www.buymeacoff.ee/CodingIsFun