Python Forum

Hi guys am new to Machine Learning and i found a dataset that i wanted to try my skills on. Its a dataset that has geo coordinates and i have to plot a map. First i have to prep the data by transforming it from wide to long data. I am stuck at this point. I am using Jupyter notebooks. I have attached the dataset and [attachment=1151]would appreciate help on how to deal with this dataset.

Thanks

Show what have you tried and what expected output/outcome is.

I have tried the melt function (df_lat = df.melt(id_vars=["id"], var_name="lat/lng", value_name="cord")) but don't get the result am looking for. I would like to have 3 columns; id, lat, lng.