Complex lon/lat format manipulation

I originally developed a model to work with a df as df1_ref. Now, I found more data I need in a different format as df2.