I have riding GPS data that I’m trying to manipulate, process and append at the end of an xls file (master data used for a map)
Original: data that comes in Formatted: the way I want the data to look
add 3 new columns: Ride, Day, Location
Location comes from the column k in original file
ride and Day I want to start at a specific number ie 285 ride, 288 day and so on
(285 because the master has 284 rides and 287 days)
So…for each new rides + 1 ride and + 1 day
Try this. I couldn’t figure out a way to extract the rides and days from the original data. The component has integer widgets to input the starting points. It will then automatically add the correct incremented number of rides and days. Your groups aren’t grouped by minutes. They’re grouped by 10 minutes at least according to the sample output you provided. I reintroduced the original time in the output. The way the locations are stored is really bad, but I was able to extract them. Let me know if this works.
original.csv (1.5 MB)
thanks
Day doesnt seem to work, as all rides have the same date, in fact all rides are on a different day Output.csv (39.0 KB)
Also in original, 1/06/2025 (the first ride) has 3746 rows but only a fraction show up in the output file
Could you explain what you want to do? Are the lat/lons starting points or does each “trip” have a starting and ending point? Similarly with the time. Are the times increments in a trip? If so, how can we separate the trips? The workflow I built for your original data groups the trips by time. That won’t generalize if you have duplicate times. Bottom line - you need something to join the location names to the rest of the data. I don’t see anything without more explanation.
@FredFery here are some more examples that might help. I might take a look at the data later. But I agree with @rfeigel: you will have to define what you want to do and how groups are defined. The definition can be complex but it will have to follow a logic.
So every day, the rides have a different Ride #, day and time
time: when the ride start and finish
lat and long are for each rides, location of the rides start and finish
Day in incremental - every day, one more ride , etc…
Ride could have multiple entries per day (if he has 2 rides in the same day)
For the tableau map i end up with a rather large excel file that contains all of rides from he started - I’m sure I could have set it up a bit better when he started in 2024
location names is only cosmetic reasons for the end map. When GPX files are exported, location names (from Garmin) are stored in column K “name” Karangasem Cycling + Cairns Cycling + Mareeba Cycling…
i think these name are assigned by Garmin based on the location
what I do manually is add the names for each rides, so the names display in the map
