3 ms·
I bet there is a space there for something between R and Excel. Something where everything is "as-code" in a scm friendly format but the primary interaction co
by colechristensen 8y ago
I bet there is a space there for something between R and Excel. Something where everything is "as-code" in a scm friendly format but the primary interaction could be equally powerful in a text editor or a cell space.
The "workbook" path of things like Jupityr is close.
- omaranto 8y agoI'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.
- LolWolf 8y agoYou can do this with xlwings![0] Would highly recommend. —— [0] https://www.xlwings.org https://www.xlwings.org
- Bishonen88 8y agoI 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].
- LolWolf 8y agoYeah, 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.
- x1798DE 8y agoJupyter 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.
- hsribei 8y agoI hear good things about spreadsheet functionality in org-mode.
- ycombinete 8y agoI use Orgmode. A lot. It's my primary organisation method, as the General Manager for a small 3 person sub-company, as well as my household organisation. I've always, unwittingly, organised myself via two systems: 1. Lists 2. Matrices I love the tables in Orgmode [0]. They are intuitive, simple, and just beautifully done. That said, the spreadsheet functionality is a different beast altogether. Even though it's the same interface as the tables, it adds an exponential layer of complexity, and separation from how most people view a spreadsheet. It's powerful, but a bit daunting, and I don't see many journalists being able to grok it. [0] https://www.youtube.com/watch?v=JHKrTsiz4JU&index=25&list=PLVtKhBrRV_ZkPnBtt_TD1Cs9PJlU0IIdE https://www.youtube.com/watch?v=JHKrTsiz4JU&index=25&list=PL...
- ycombinete 8y agoI just discovered that you can actually use Org's Tables as R data frames, and all sorts of other R actions from within Org. [0] So that's quite amazing. [0] http://ehneilsen.net/notebook/orgExamples/org-examples.html#sec-22 http://ehneilsen.net/notebook/orgExamples/org-examples.html#...