• 0 Posts
  • 10 Comments
Joined 2 months ago
cake
Cake day: February 23rd, 2025

help-circle




  • Turturtley@aussie.zonetoBuy European@feddit.ukExcel alternative
    link
    fedilink
    English
    arrow-up
    17
    ·
    edit-2
    20 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.




  • I tried Obsidian, but it didn’t give me anything extra on top of using Helix with Marksman, dprint and git. 1% the ram usage of obsidian, versioning, auto-formatting, link auto-complete, page pickers/traversing, global search, etc. there’s literally no reason to use more electron bloatware.

    I basically use Markdown files for anything i would’ve done in Word, and python streamlit + pandas + csv files for anything done in Excel (and capable of handling millions of rows more performantly)