FOSS Data Science Alternatives - Desktop Data Management

Desktop Data Management

Problem solved: How to manage data on your desktop

Use cases for managing data:

• Entry
• Filtering and sorting
• Search data for fields, rows
• Analysis, query
• Viewing with easy data changes
• Storage
• Visualization

Software:

• NF: Excel
• FOSS: LibreOffice Calc
• Other open source - more different from Excel but similar or more powerful functionality:
  • RStudio (AGPL license)
  • VS Code
  • Emacs
  • Spyder (MIT license, some limits compared to RStudio)
  • Python, Jupyter Notebook, and other programming languages
  • Visidata

Research on How to Replace Excel

• Explore Python and data frame viewing:
  • Using Anaconda for environments and packages https://docs.anaconda.com/free/anaconda/getting-started/index.html
    • Windows scoop: https://scoop.sh/#/apps?q=anaconda
  • Use visidata
• Go through all pages of - recorded to learning
  • https://github.com/stefmolin/pandas-workshop/tree/main learning at Data Science Pandas Workshop - Introduction to Data Science with Pandas
• VS Code and Data Science
  • Data science tutorial
  • Python interactive and others
• Optional: https://www.freecodecamp.org/learn/data-analysis-with-python/
• Real use cases
  • Search and replace text - Google Ads Fawcett Tree Removal csv data
  • Find string, extract rows with string - Finding row for a solution in solutions detail and extracting row
  • ADDS reporting domains
    • Filter unfinished domains
    • Popular Beausoleil domain information