News for hackers. Stuff that matters.
Re:How a New York Times Software Engineer Ended Up Covering ... by omaranto on Thursday September 13, 2018 @01:33AM (#17976297)
I'd love a little spreadsheet widget for Jupyter that was only for data entry (i.e., a formula-less spreadsheet) and produced a Pandas dataframe.
Re:How a New York Times Software Engineer Ended Up Covering ... by LolWolf on Thursday September 13, 2018 @02:14AM (#17976429)
You can do this with xlwings![0] Would highly recommend.

——

[0] https://www.xlwings.org

Re:How a New York Times Software Engineer Ended Up Covering ... by Bishonen88 on Thursday September 13, 2018 @05:35AM (#17977240)
I don't believe that's what the poster meant, which you're replying to. xlwings is a python library used to connect to excel files and e.g. change their contents programmatically. I don't think you can use it (out of the box anyway) to display and change data 'as-a-spreadsheet' in a jupyter notebook [e.g. by showing an iframe].
Re:How a New York Times Software Engineer Ended Up Covering ... by LolWolf on Thursday September 13, 2018 @12:05PM (#17979677)
Yeah, unsure about what the parent may have intended. I use it as a data IO for stuff that I want to manipulate in Python somewhat-interactively, by having an Excel sheet open on the side as I work in Python.
Re:How a New York Times Software Engineer Ended Up Covering ... by x1798DE on Thursday September 13, 2018 @07:24AM (#17977728)
Jupyter lab has a spreadsheet editor. I haven't actually used it so I'm not sure if you can calculate with it, but I'd be mildly surprised if you could.