š Recorded at PyCon DE & PyData Berlin 2024, 23.04.2024
https://2024.pycon.de/program/UPSJEM/
š Watch how Python in Excel revolutionizes advanced data analytics, unlocking unprecedented data science and machine learning use cases directly in your Excel workbooks.
Speakers:
Valerio Maggio
Description:
Valerio Maggio, a data science expert, introduced the new Python in Excel integration created by Microsoft during the tutorial. This innovation enables users to seamlessly embed Python code directly into Excel workbooks for advanced data analytics. Python in Excel leverages the Python Anaconda Distribution running in the Microsoft Cloud, granting immediate access to a wide array of packages essential for data science, visualization, and machine learning applications. The integration automatically integrates the output of Python code executions into the spreadsheet, providing interactive data reports that can be shared with ease. Currently available in public preview for all users on the MS Excel Beta Channel for Windows, Python in Excel offers limitless possibilities for data manipulation, validation, and visualization within the familiar Excel environment. The tutorial focused on exploring the various features and potentials of this integration, guiding attendees through executing Python code in Excel, and culminating in creating a complete machine learning experiment directly within Excel. Familiarity with Excel and Python is the minimal requirement for attendees to benefit from this tutorial. To set up Python in Excel, users need to join the Microsoft 365 Insider Program at the Beta Channel level and can enhance their experience by installing the Excel Labs plugin, which includes a Python editor for easier Python script authoring in Excel. To get hands-on experience, users can download the Financial Sample Excel Workbook provided by Microsoft.
āļø About PyCon DE & PyData Berlin:
The PyCon DE & PyData conference unite the Python, AI, and data science communities, offering a unique platform for collaboration and innovation. The PyCon DE & PyData Berlin 2024 conference, hosted in partnership with the local Berlin PyData chapter, provided an exceptional experience, fostering deeper connections within the Python community while showcasing advancements in AI and data science. Attendees enjoyed a diverse and engaging program, solidifying the event as a highlight for Python and AI enthusiasts nationwide.
Follow us:
ā¢ LinkedIn: https://www.linkedin.com/company/28908640/
ā¢ X: https://www.x.com/pyconde
ā¢ X: https://www.x.com/pydataberlin
Links:
ā¢ Conference website: http://pycon.de
ā¢ Related sessions: http://2024.pycon.de/program/categories/pydata-pydata-scientific-libraries-stack
The conference is organized by
ā¢ Python Softwareverband e.V.: http://pysv.org
ā¢ NumFOCUS Inc.: http://numfocus.org
ā¢ Pioneers Hub gemeinnĆ¼tzige GmbH: http://pioneershub.org
If you enjoyed this session, please like, comment, and subscribe to our channel for more insightful talks and discussions.
Share this video with your network to spread the knowledge!
Hashtags:
#Python #PyConDE #PyData #OpenSource #AI #DataScience #MachineLearning #SoftwareDevelopment #LLMs #Community
Acknowledgements:
Special thanks to all the volunteers and sponsors who made this event possible.
About:
Python Softwareverband e.V.:
PySV is a non-profit that promotes the use and development of Python in Germany through events, education, and advocacy, fostering an open Python community.
NumFOCUS Inc.
supports open-source scientific computing by providing financial and logistical support to key projects like NumPy and Jupyter, promoting sustainable development and collaboration.
Pioneers Hub gemeinnĆ¼tzige GmbH:
is a non-profit fostering innovation in AI and tech by connecting experts and promoting knowledge exchange through events and collaborative initiatives.
www.pydata.org
PyData is an educational program of NumFOCUS, a 501(c)3 non-profit organization in the United States. PyData provides a forum for the international community of users and developers of data analysis tools to share ideas and learn from each other. The global PyData network promotes discussion of best practices, new approaches, and emerging technologies for data management, processing, analytics, and visualization. PyData communities approach data science using many languages, including (but not limited to) Python, Julia, and R.