• 0 Posts
  • 24 Comments
Joined 1 month ago
cake
Cake day: February 23rd, 2025

help-circle










  • Turturtley@aussie.zonetoBuy European@feddit.ukExcel alternative
    link
    fedilink
    English
    arrow-up
    14
    ·
    edit-2
    16 days ago

    A bit of an unusual suggestion, but i’ve replaced Excel with Python. I deal with large datasets anyway, so Python was arguably a better fit for what i do.

    Packages to check out to see what is possible…

    • Streamlit = easy UIs, dashboards, and tables.
    • Pandas = dataframe handling, excel, csv ingestion
    • Numpy/Scipy = math
    • Sqlalchemy/pyodbc = DB connectivity
    • xlsxwriter = writing out to exls
    • DuckDB = in-memory joins/transformations locally between dataframes using SQL. Basically all the power of a relational DB without a DB server.
    • Plotly = graphing

    Everything is in text files. Scripts are version controlled in git. Calcs happen super fast. I spend more time transferring data from DBs than waiting for the calcs to finish.


  • Hmm… the way i’ve taught it is biomechanical in nature.

    I assume you are pressing the brakes using your toes. You’ll want to switch to using the middle of your foot. Specifically, plant your ankle up as close as possible to the brake pedal, and keep it planted there. To brake, you pivot on the ankle. This should give you more control to apply gradual pressure on the pedal.









  • Re: Office Suite, i’m slowly persuading my work to move to all text based. Markdown to replace Word docs. Csv files and python scripts (streamlit, pandas, numpy, scipy, duckdb, plotly) to replace excel & power bi. Markdown and Slides to replace powerpoint. Git to replace sharepoint.

    Imo, all corporate & government documentation should be in plaintext. Changes easily tracked, versioned, inspected, and audited.

    Helix editor with markdown and python LSPs and formatters has been my stack for all my personal documentation/personal finance for years, so i know the approach works. And since it’s just plain text, anyone can use their preferred editor. Vim, emacs, etc