demo2 / pre_process.py
anofa's picture
Upload 57 files
85c7386 verified
raw
history blame
831 Bytes
#%%
import pandas as pd
import geopandas as gpd
df = pd.read_excel('/Users/huseyin.kaya/Downloads/Tomorrowville_Dataset/TV_Others/VS2/_outputs/Layer_Building_VS2.xlsx')
#df = pd.read_excel('/Users/huseyin.kaya/Downloads/Tomorrowville_Dataset/TV_Others/VS1/_outputs/Layer_Individual_VS1.xlsx')
#df.to_json('individual_tv50_1.json')
#df = df.rename(columns={'X':'x','Y':'y','IM':'im'})
gdf = gpd.GeoDataFrame(df, geometry=gpd.points_from_xy(df.xcoord, df.ycoord))
gdf.set_crs(epsg=32645, inplace=True)
gdf = gdf.to_crs(crs="EPSG:4326")
gdf.xcoord = gdf.geometry.x
gdf.ycoord = gdf.geometry.y
#gdf = gdf.sample(n=1000)
gdf = gdf.reset_index(drop=True)
#gdf = gdf.drop(columns=['xcoord','ycoord'])
#gdf = gdf.drop(columns=['geometry'])
gdf.to_file('building_tv50_2.geojson', driver="GeoJSON")
#%%