block3.py

# select relevant columns
df_compressed = df_sensorData[["loggingTime(txt)",
                               "locationTimestamp_since1970(s)",
                               "loggingSample(N)",
                               "locationLatitude(WGS84)",
                               "locationLongitude(WGS84)",
                               "locationAltitude(m)",
                               "locationSpeed(m/s)",
                               "accelerometerTimestamp_sinceReboot(s)",
                               "accelerometerAccelerationX(G)",
                               "accelerometerAccelerationY(G)",
                               "accelerometerAccelerationZ(G)",
                               "gyroRotationX(rad/s)",
                               "gyroRotationY(rad/s)",
                               "gyroRotationZ(rad/s)"]]

# shorten names of columns
df_compressed = df_compressed.rename(index=str,
                                    columns={
                               "loggingTime(txt)":"time",
                               "locationTimestamp_since1970(s)":"time_s1970",
                               "loggingSample(N)":"sample_ind",
                               "locationLatitude(WGS84)":"lat",
                               "locationLongitude(WGS84)":"lon",
                               "locationAltitude(m)":"altitude",
                               "locationSpeed(m/s)":"speed",
                               "accelerometerTimestamp_sinceReboot(s)":"accel_time",
                               "accelerometerAccelerationX(G)":"x",
                               "accelerometerAccelerationY(G)":"y",
                               "accelerometerAccelerationZ(G)":"z",
                               "gyroRotationX(rad/s)":"Xgyro",
                               "gyroRotationY(rad/s)":"Ygyro",
                               "gyroRotationZ(rad/s)":"Zgyro"})