• 0 Posts
  • 3 Comments
Joined 26 days ago
cake
Cake day: February 23rd, 2025

help-circle
  • Turturtley@aussie.zonetoBuy European@feddit.ukExcel alternative
    link
    fedilink
    English
    arrow-up
    8
    ·
    edit-2
    1 minute 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.