File1=
[[test1,3],
[ test5, 6],
[test3, string],
[Random, 8]]
File2=
[[test2, 5],
[test5, 8]]
File3=
[[test5, yes],
[test3, no],
[Random, no]]
Reality, these files are hundreds of rows. First column is a string. About 30 different files. Mixed data.
I would like to get an output file like the following, which finds all unique column 1 ids and fills in data from each file.
The column 1 Id May not exist for each file.
Result=
[[test1, 3, nan, nan],
[test2, nan, 5, nan],
[test3, string, nan, no],
[test5, 6, 8, yes],
[random, 8, nan, no]]