Turn Your Excel Data Into An Interactive Dashboard Using Python | Pyecharts Tutorial

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
If you have a lot of data and want to look at it more quickly and intuitively, then this video is for you. In this video, I will show you how to use Python to turn your Excel data into a neat dashboard. We'll learn how to use Python's powerful libraries like pandas and pyecharts to transform boring numbers into beautiful charts.

🌍 𝗟𝗜𝗡𝗞𝗦:

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Introduction
00:31 – Create Pandas DataFrame
02:09 – Install Pyecharts
02:33 – Data Preparation
03:38 – Plot Sales and Profit by Months
05:25 – Plot Sales and Profit by Subcategory
06:52 – Plot Sales Calendar Heatmap
09:26 – Export Dashboard
10:30 – Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[CodingIsFun]

Do you want to see more pyecharts tutorials? Let me know in the comments!

[rajeshsn]

Not just the content, but the way you have arranged each topic and provided timestamp for each step, simply superb.❤❤ I am watching all your video's

[Lordofunderground]

Hey Sven, I have recently started watching your videos but with this one you really blew my mind. Great job as always, and thank you for all these tutorials you constantly upload for us, really appreciated

[amroman]

Yes please i fall in love with pyecharts module, it it portable and can be shared which is awesome, i am looking for tutorials to provide more controls in dashboards like search fields

[findthetruth]

Yes please, that was awesome please make all type of analysis with it and type of charts in the coming videos. That was so much fun and amazing.

[kurosakishusuke]

Awesome video on presenting an alternative library to matplotlib and seaborn.

[houmadinaif-chakrou]

This is the better tuto I have never seen

[marypeter]

Wow its breathtaking.. Awesome.. Cant wait for more

[sean]

thanks very much Sven, you're the best!!

[alaverdyan]

Amazing tutorial for a great library! The syntax reminded me of that of ggplot2. Will definitely have a try!

[DeepakChauhan-mnjw]

Thanks a lot. This is amazing. Would love to see more content on Pyecharts.

[GenNextAnalyst]

This looks interesting! More please =)

[At_Ant]

Great tutorial 👍. Interactive charts are what I need for work to make sharing information more efficient. The other options are lots of static charts or dashboards, but these aren’t appropriate in many use cases.

[baoluu]

Amazing, that 's blow my mind. Very thank you!

[freedomchaser]

Awesome video. Thank you as always, Sven. Just bought your add-in. Look forward to putting it to great use.

[mrmuranga]

looks amazing, will definately give it a try...

[zibivaxmeterinstall]

great video, I need to lean more about this, for instance running the graph in a django app

[ricardo.alves.campos]

Yes, we need absolutely more videos on that. Do you think it is possible to have more than on chart per tab?

[KhalilYasser]

Amazing and awesome. Thank you very much.

[willymays]

¡Excelente video! Mas tutoriales por favor