No video :(

Python in Excel is a GAMECHANGER

Подписаться 98 тыс.

Просмотров 11 тыс.

50% 1

👉 Explore All My Excel Solutions: pythonandvba.c...
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video, I take a close look at the promising fusion of Python within Excel, and it's quite a transformative experience. From the basics of converting Excel tables into Pandas dataframes for more structured data handling to crafting visual data narratives using Matplotlib and Seaborn, I cover it all. As a practical application, I offer an in-depth analysis of a Japanese sales transaction table, extracting valuable insights directly within the Excel environment. Along the way, I'll share my thoughts on this integration and discuss some limitations that users might face.
🌍 𝗟𝗜𝗡𝗞𝗦:
▶ Pandas Tutorial: • Become a Pandas Pro: L...
▶ @LukeBarousse YT-Channel: / @lukebarousse
💡 Want to learn about Python in Excel? Check out the detailed tutorials from Anaconda: anaconda.com/excel
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
0:00 - Introduction
0:39 - Starting with a Basic Example
3:45 - Diving into a Real-World Analysis
9:05 - Sharing My Thoughts on Python in Excel
11:36 - Discussing the Limitations of Python in Excel
12:00 -Outro
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.c...
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.c...
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): pythonandvba.c...
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.c...
📑 Excel Templates: pythonandvba.c...
🎓 My Courses: pythonandvba.c...
📚 Books, Tools, and More: pythonandvba.c...
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sve...
💬 Discord: pythonandvba.c...
📬 Contact: pythonandvba.c...
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ pythonandvba.c...

Опубликовано:

18 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 48

@CodingIsFun 11 месяцев назад

*What do you think about the integration of Python in Excel? Let me know in the comments!* Also, here's the link to the MyToolBelt add-in: pythonandvba.com/mytoolbelt

@LukeBarousse 11 месяцев назад

My dude, I'm glad to see you got access!! Also, your Excel sheets are SO organized; I need to get on your level! 🙌🏼 My spreadsheets look like a hot mess 🔥💩

@CodingIsFun 11 месяцев назад

Thanks to you, Luke, I got access 🙏. Just did a bit of housekeeping 🧹 in my spreadsheet before recording my screen 😅

@iotlalo 11 месяцев назад

Amaizing video

@CodingIsFun 11 месяцев назад

Thanks a lot! :)

@Mandelbrot567 11 месяцев назад

As I am retraining as a data analyst I have been learning python with pandas recently and am really pleased with this development. I was not looking forward to learning TypeScript as well so hopefully python will be a good option.

@CodingIsFun 11 месяцев назад

Thanks for watching. It's definitely worth learning Python + Pandas 👍 Happy Coding! :)

@MariusSc 11 месяцев назад

This will be soooo nice 😍

@CodingIsFun 11 месяцев назад

Yes, indeed! :)

@eska3389 11 месяцев назад

Top Video. Thank you...i didnt know about that. I work with vba...but vba will Not be Further development...so to know about the possibility wird python is goof to know :)

@CodingIsFun 11 месяцев назад

Glad you liked the video. Yes, give Python a try :) That said, for automating tasks in spreadsheets (e.g., copying data from A to B), I think VBA is still a valid option.

@user-rr7yi3ru2p 7 месяцев назад

Cool!!! Integration of everything with everything, soon it will be possible not to leave the house at all, all desires will be fulfilled instantly:)

@CodingIsFun 7 месяцев назад

Thanks for watching!

@nafizhaq4554 8 месяцев назад

hey thanks for sharing! Would you do a series of video to use python and panda in excel?

@CodingIsFun 7 месяцев назад

Thanks for watching. Yes, maybe in the future! :)

@ixternal9295 11 месяцев назад

Seems like it'll be useful for some things but mostly irrelevant for the majority of cases where you would use python over excel.

@CodingIsFun 11 месяцев назад

Thanks for watching. I can imagine using it for a dynamic pivot table with pandas (linked to cells to maintain its dynamism), charts not found in native Excel, or even some basic Machine Learning. Of course, its applicability really depends on your use case. As mentioned in the video, I see it as another tool in your toolbox. You might not need it daily, but when you do, it's great to have on hand.

@dincerdogan804 10 месяцев назад

Thank you so much

@CodingIsFun 10 месяцев назад

You're very welcome! Thank you for watching and for the comment!

@m.bouguerra 5 месяцев назад

a big thank you for this valuable information, and I would like to practice on the example file of your tutorial, can you share it.. thank you again... I am an Algerian who follows you

@CodingIsFun 4 месяца назад

Thank you for watching. I'm glad you liked the video. You can find the Iris dataset here: github.com/plotly/datasets/blob/master/iris-data.csv Note that it's in CSV format. Simply open it with Excel and save it as an XLSX file. Happy Excelling & Coding! Cheers, Sven ✌️

@m.bouguerra 4 месяца назад

@@CodingIsFun The IRIS sample data exists in the initialization pane of python, anyone can download it easily. I am looking for the data table in the chapter (9:05 - Sharing My Thoughts on Python in Excel) with 11 columns, which starts with the city column and ends with the SalesAmount column.. thank you

@CodingIsFun 4 месяца назад

@@m.bouguerra Ah, I see. You can download it here: filedn.eu/lV0RcQd1Re5jQr5XL93Ntwm/PY_in_XL_DEMO.xlsx

@echidne 11 месяцев назад

For the moment I think the limitations are too important (working only with 365 online) I prefer to use the tools already in place like xlwings or your toolbelt. I'm wondering also what are the sizes of your excel files with Python inside?

@CodingIsFun 11 месяцев назад

Thanks for watching and using the MyToolBelt add-in 👍 It actually works with the Microsoft Excel Desktop version on 365 too. The file size largely hinges on your activities. If it's "just code", it shouldn't impact the file size significantly. But for me, since I've rendered several charts, it naturally increased the file size. xlwings is a fantastic library, and definitely also one of my favorites for Excel automation and data manipulation.

@echidne 11 месяцев назад

but how excatly is it working? Did Microsoft embedded all python standard library + anaconda libraries in Excel? Or for teh moment is just working online because they use servers with installed python and libraries?@@CodingIsFun

@theeurostep6777 11 месяцев назад

Hopefully this goes through beta stage soon.

@CodingIsFun 11 месяцев назад

Hope so too!

@memolingvo5563 5 месяцев назад

How to install the Python libraries which are missing in the Python for Excel?

@CodingIsFun 5 месяцев назад

Thanks for watching. Please have a look here: support.microsoft.com/en-au/office/open-source-libraries-and-python-in-excel-c817c897-41db-40a1-b9f3-d5ffe6d1bf3e

@RashmilDahanayake 11 месяцев назад

Which version of Excel supports this? Or do you have to enable a specific tool bar?

@CodingIsFun 11 месяцев назад

Thanks for watching. As mentioned in the video, MS Excel 365. Check out the "Getting Started" section: techcommunity.microsoft.com/t5/microsoft-365-blog/introducing-python-in-excel-the-best-of-both-worlds-for-data/ba-p/3905482

@GamePulseMemes 11 месяцев назад

is it available for excel 2021 version

@CodingIsFun 11 месяцев назад

Thanks for watching. Nope, as mentioned in the video, currently it is only available for Microsoft 365 Beta channel users.

@GamePulseMemes 11 месяцев назад

@@CodingIsFun And how i can became the member of Microsoft 365 beta channel user

@CodingIsFun 11 месяцев назад

@@GamePulseMemes techcommunity.microsoft.com/t5/microsoft-365-blog/introducing-python-in-excel-the-best-of-both-worlds-for-data/ba-p/3905482 Scroll to the "Get started with Python in Excel" section

@__________________________6910 11 месяцев назад

You always wanted Python in Excel

@CodingIsFun 11 месяцев назад

Yes, a dream is coming true ✨

@__________________________6910 11 месяцев назад

@@CodingIsFun ❤

@FoobsTon 7 месяцев назад

under the formulas ribbon you will see Python.....err, no, it's not there.

@CodingIsFun 7 месяцев назад

Thanks for watching. The answer to your error: 11:46 min

@HarshColby 9 месяцев назад

Python in Excel is so slow it's useless. I hope they fix that before making it publically available to everyone. It's way faster to write an external python program to open Excel and make updates.

@CodingIsFun 8 месяцев назад

Thanks for watching and your sharing your thoughts!

@Shubham.y31 11 месяцев назад

Hey, Sven can i be your RU-vid thumbnail designer. I will design your Thumbnails more eye catching to engage people. I recently design your Thumbnail topic name AI app. Pleas

@CodingIsFun 11 месяцев назад

Thanks for watching the video?! 😅 You might want to reach to me here: pythonandvba.com/contact Thanks!

@peterxxl1244 11 месяцев назад

A really stupid idea. The last thing an Office user needs is another programming language whose ONLY obvious use is to call FUNCTIONS from a function LIBRARY, which in turn was written in completely different languages. It would have made much more sense to make libraries like NumPy or Pandas directly accessible for VBA, instead of converting table cells into uncomfortable editor fields for Python scripts (this is also possible with other libraries whose functions can be called as functions or formulas). If I only need Python to call C, C++ or Rust functions, there is a lot wrong. What Microsoft thought about this remains mysterious - the explanations are anything but rational - it will probably be about economic interests. Probably they have seen that obviously many people like to program in Python and want to bind them as new customers, what do I know. Once again, it's a stupid, completely unnecessary idea - and I'm not saying that because I have something against Python, but I would also say that if it were any programming language.

@logenninefinger3420 11 месяцев назад

Not exactly what you would call an editor. Bah.. terrible, who really uses that?

@clay4gli 10 месяцев назад

There are millions of excel users through the world. Now they have the chance to use a real programming language to help them clean their data, perform reconciliations, and automate bring tasks. If you are a truly professional Python programmer, yeah, you are probably not impressed. This gives us users the opportunity to learn enough to help us with our specific needs. This is a great video and Python will be useful to millions of excel users.