I have two csv dataframe files, one containing data of albums from 2015-2017 (file 1) and one containing data of tv shows from 2018-2020 (file 2). i have to merge these into one file.
The columns with information include
file 1: release year, series title, overview, genre, number of episodes, rating, certificate.
file 2: release date, title, overview, genre
There is no overlapping data between the two files, so no common keys