All my life I've been using excel. This week my team is fucked after the raw data we have to work with consists of 800k+ rows sheets per week, with 50+ files to process. I submit to coders supremacy. How should I pursue programming after excel? Programming always seems intimidating

This page summarizes the projects mentioned and recommended in the original post on /r/learnprogramming
Science and Data analysis CSV Data Analysis notepad-plus-plus Pandas

InfluxDB
Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
Our great sponsors

  • Pandas

    Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more

  • CSVLint

    CSV Lint plug-in for Notepad++ for syntax highlighting, csv validation, automatic column and datatype detecting, fixed width datasets, change datetime format, decimal separator, sort data, count unique values, convert to xml, json, sql etc. A plugin for data cleaning and working with messy data files.

    • Does the raw data consist of CSV files? If so I just want to mention that there is a CSV Lint plug-in for Notepad++, which can do some basic error checking, and generate a Python or R script based on the column metadata. The generated script just reads the CSV file into a dataframe, and does need further coding, it's just a starting point so to speak.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts