Exported data from access has redundant data, how do we deal with this?

[jurra]

This is a row in the Cores table exported as csv, please look at the last three fields. Why is this like this. We have a Date time combined field, and then separate Date and Time. I would expect them to be the same and consistent, but they are not.

id                                                                           37
registered_by                                                                 3
well                                                                    DELGT01
core_number                                                                  C1
core_section_number                                                         1.0
core_section_name                                                  DELGT01-C1-1
collection_date                                                      2023-08-10
planned_core_number                                                          C1
unplanned_core                                                               No
top_depth                                                                2511.5
bottom_depth                                                             2512.5
remarks                                             vacuum sealed on 16-08-2023
core_section_length                                                         1.0
core_recovery                                                               NaN
core_diameter                                                                 4
coring_method                                                               NaN
coreliner                                                              Aluminum
drilling_mud                                                      Oil-based mud
formation                                                                   NaN
lithology                     TOP: very hard, coarse silt, m-grey-brown, dar...
core_status                                                           Preserved
preservation                                                                NaN
Core in Barrel Weight [kg]                                                  NaN
ct_scanned                                                                  NaN
gamma_ray                                                                   NaN
weight                                                                     27.8
radiation                                                                   2.4
ct_scanned.1                                                                Yes
registration_date                                              2023-08-21 11:30
Registration Date                                                    2023-08-10
Registration Time                                                         14:43

[anailil]

In the database are only the last two fields, something when wrong and the combine field remained. The following fields should be removed: registration_date ct_scanned.1 Core in Barrel Weight [kg]