Performing complex CSV data wrangling tasks with ease

This page summarizes the projects mentioned and recommended in the original post on /r/vba

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

    The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.

    Compute 3P%. The first stage of our solution will be completed using the File System Object (FSO), so that we can indicate the path to the folder containing the data we wish to analyze. The desired goal can be achieved with very simple code. To complete the second stage, we will need to use a library that allows us to import, filter and handle results from different queries on CSV files; we will use for this purpose the CSV Interface library. Finally, we must compute the effectiveness of three-point shots made by LeBron James. It is clear that the task described is far from simple, but we will show that it can be achieved with readable, concise and extensible VBA code.

  • 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.

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