I am not very savvy at using Python. Actually I have around 1000 output files from using the tool zonal statistics as table in ArcGIS. The names of the files are jan_60, feb_60......dec_13. These all lie in one folder. Each of these files contain an ID and Name field which are my identifiers. And each file has got a column of interest called Mean. So what I want is that all the files be merged, using ID and name field. In the final table, I want one column added having the mean values from each of the individual tables. Note that I want the name of the new columns as the original file name. I am trying to give you a visualization below:
original files I have:
ID Name Mean
output file needed:
ID Name jan_60 feb_60 march_60
Can someone help me out, if any of you have had a similar task. It would be great if I can have a script or something. Thanks a lot.
output file needed folder containing individual files
one of the individual