News for hackers. Stuff that matters.
Re:Excel Never Dies by Robotbeat on Monday March 08, 2021 @11:59AM (#26388063)
What non-spreadsheet programming languages/environments do you think work better than Python/Jupiter?

I’ve been fairly happy with the default Matlab IDE personally. Visibility and representation of data has the straightforwardness of a spreadsheet. But surely there must be others?

Re:Excel Never Dies by hypermachine on Monday March 08, 2021 @12:06PM (#26388169)
A lot of environments do not have easy to use hot reloading out-of-the-box (and also quick GUI creation support). This is the primary reason why development feels less intuitive in a lot of text based languages versus more visual tooling like Excel which can give instantaneous feedback.

Hot reloading is most famous for being a staple of Lisp languages (but they tie it to the repl rather than as a standalone feature). For Microsoft languages this is provided by Visual Studio (commonly known as edit-and-continue, it is available in some form or other since the original VB days). You can try it out with the embedded VBA interpreter in Excel (under the Developer tab).

For JavaScript this is a recent innovation (driven primarily by the React/SPA crowd). In Java, most IDEs have the feature but it requires a fair bit of setup and configuration (look up hot swap for Intellij). The closest thing Python has is Jupyter which admittedly is not that pleasant to use.

Re:Excel Never Dies by lispm on Monday March 08, 2021 @12:24PM (#26388477)
> but they tie it to the repl rather than as a standalone feature

Lisp has a function called LOAD, which can load source and/or compiled code.

Re:Excel Never Dies by hermitcrab on Monday March 08, 2021 @03:04PM (#26390773)
There are a number of visual data transformation environments, including https://www.easydatatransform.com (I am the developer), https://www.alteryx.com and https://www.knime.com .
Re:Excel Never Dies by twobitshifter on Monday March 08, 2021 @02:45PM (#26390558)
Julia in VSCode is nice. The speed gains from Julia are worth it alone if you are working with large datasets.
Re:Excel Never Dies by Robotbeat on Monday March 08, 2021 @06:47PM (#26393269)
I’m putting this on the long list of reasons to eventually migrate to Julia.
Re:Excel Never Dies by airstrike on Monday March 08, 2021 @12:10PM (#26388222)
> What non-spreadsheet programming languages/environments do you think work better than Python/Jupiter?

RMarkdown + RStudio + knitr

Re:Excel Never Dies by jdgoesmarching on Monday March 08, 2021 @12:25PM (#26388500)
I really wish Python had the kind of support for Markdown that R does. Notebooks are fine, but the simplicity of having essentially a plain text file is just amazing.
Re:Excel Never Dies by Something1234 on Monday March 08, 2021 @02:25PM (#26390315)
Rmarkdown theoretically supports python. I haven't used it though.
Re:Excel Never Dies by vharuck on Monday March 08, 2021 @04:58PM (#26392215)
Knitr theoretically supports anything you can call from R. Chunks pass their code and options to "engine" functions that return the results. Knitr provides a bunch of engines out of the box (Python, awk, SQL). But you can also write your own.

yihui.org/knitr/options/#language-engines

I once made a SAS engine to show coworkers how to adopt report automation without having to rewrite all existing code.