Python

6400 readers

16 users here now

Welcome to the Python community on the programming.dev Lemmy instance!

📅 Events

Past

November 2023

PyCon Ireland 2023, 11-12th
PyData Tel Aviv 2023 14th

October 2023

PyConES Canarias 2023, 6-8th
DjangoCon US 2023, 16-20th (!django 💬)

July 2023

PyDelhi Meetup, 2nd
PyCon Israel, 4-5th
DFW Pythoneers, 6th
Django Girls Abraka, 6-7th
SciPy 2023 10-16th, Austin
IndyPy, 11th
Leipzig Python User Group, 11th
Austin Python, 12th
EuroPython 2023, 17-23rd
Austin Python: Evening of Coding, 18th
PyHEP.dev 2023 - "Python in HEP" Developer's Workshop, 25th

August 2023

PyLadies Dublin, 15th
EuroSciPy 2023, 14-18th

September 2023

PyData Amsterdam, 14-16th
PyCon UK, 22nd - 25th

🐍 Python project:

💓 Python Community:

#python IRC for general questions
#python-dev IRC for CPython developers
PySlackers Slack channel
Python Discord server
Python Weekly newsletters
Mailing lists
Forum

✨ Python Ecosystem:

🌌 Fediverse

Communities

#python on Mastodon
c/django on programming.dev
c/pythorhead on lemmy.dbzer0.com

Projects

Pythörhead: a Python library for interacting with Lemmy
Plemmy: a Python package for accessing the Lemmy API
pylemmy pylemmy enables simple access to Lemmy's API with Python
mastodon.py, a Python wrapper for the Mastodon API

Feeds

founded 1 year ago

MODERATORS

[email protected]

173

Microsoft is bringing Python to Excel (www.theverge.com)

submitted 1 year ago by [email protected] to c/[email protected]

61 comments fedilink hide all child comments

Microsoft is bringing popular programming language Python to Excel. A public preview of the feature is available today, allowing Excel users to manipulate and analyze data from Python.

You won’t need to install any additional software or set up an add-on to access the functionality, as Python integration in Excel will be part of Excel’s built-in connectors and Power Query. Microsoft is also adding a new PY function that allows Python data to be exposed within the grid of an Excel spreadsheet. Through a partnership with Anaconda, an enterprise Python repository, popular Python libraries like pandas, statsmodels, and Matplotlib will be available in Excel.

you are viewing a single comment's thread
view the rest of the comments

[–] ooterness 11 points 1 year ago (2 children)

But why does it need to run in the cloud?

[–] [email protected] 5 points 1 year ago

💰💰💰 By sending every calculation to Microsoft servers they can log what your company is doing and sell that data to ad-agencies. Also it forces you into a subscription.

[–] [email protected] -1 points 1 year ago (2 children)

I'm not a fan of it either, but I'm not sure how else this could work seamlessly. How would you ensure that everyone you share your Excel file that utilizes Python has the expected Python setup on their machine? What if they have an older version of a library you used that breaks your script? What if they don't have Python installed at all?

While this will only work on Windows desktop at first, Microsoft plans to roll this out to "other platforms" over time. Is there any other way for this integration to work for Excel for web, iPad, and/or Teams?

[–] [email protected] 2 points 1 year ago (1 children)

A python distribution could be bundled inside of excel.

[–] [email protected] 1 points 1 year ago (2 children)

That's true. It wouldn't solve the dependency issue though (eg - I'm using Pandas v1.5.3, you're using Pandas v2.0.3) and I'm not sure how well it would work for some platforms like the web or Teams.

[–] [email protected] 1 points 1 year ago

I'm not sure exactly. Maybe it is one reason why they are pushing an online container. I guess then then it can have its own issues of dependency hell. At least with the container approach, everything either works or it is broken, and there is no having to verify which versions of Excel are installed to make the spreadsheet run.

I doubt the end user would have control over package versions, but I had not gotten around to playing with it yet.