[HN] Microsoft is bringing Python to Excel - eviltoast
  • Hamartiogonic@sopuli.xyz
    link
    fedilink
    arrow-up
    2
    ·
    1 year ago

    That’s good news… for people who know Python. Normally, I’ll start analyzing data in Excel, and when the calculation is about to explode, I’ll switch to R and continue there.

    I wonder if this Python integration will actually make it possible to stay with Excel a little bit longer before I have to switch to another tool. I wonder if it’s possible to replace some of my horrendously unreliable VBA trash with python. Hopefully, things won’t be quite so random and unpredictable even though the code is still running on Excel.

    Knowing how many packages are available for Python, this new integration could be really big. Imagine doing multidimensional regression with any function you can think of or drawing sankey plots or violin plots.