Hello everyone. I have a time series csv data that has 28 million rows and the following columns.
| Year | Month | Day | hour | osm_way_id | osm_start_node_id | osm_end_node_id | speed_mph_mean | speed_mph_stddev |
|---|---|---|---|---|---|---|---|---|
| 2019 | 12 | 6 | 19 | 147247978 | 6504105346 | 1604745704 | 18.72 | 1.482 |
This an example showing the columns and one example row.
The data is too much for me to open with excel or Tableau. I was advised to reduce the number of rows by aggregating the data. Please I have the following questions:
will aggregating the data actually reduce the number of rows from 28 million?
and if so, how do I aggregate the data in excel?
Is there a better platform than excel that I can use to aggregate the data? like some database?
What does it really mean to aggregate a time series data?
Thank you very much.
