+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: Geo dataset help (/thread-34029.html)
Geo dataset help - aamanyire - Jun-19-2021
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
RE: Geo dataset help - buran - Jun-19-2021
Show what have you tried and what expected output/outcome is.
RE: Geo dataset help - aamanyire - Jun-19-2021
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.