ba_preprocessing's Introduction

BA_Preprocessing

Processing of Seoul Bike Rental Station Information

File Information

seoul_bicycle_master.json
: Master data of Seoul Bike rental stations
master_preprocessing.ipynb
: Normalizes the coordinates in the master data where they are recorded as 0.0 using the Google API
seoul_bicycle_maser_preprocessed.csv
: File containing data processed using master_preprocessing.ipynb
master_info_with_nearby.ipynb
: Adds columns of data for the nearest rental station and its distance using seoul_bicycle_maser_preprocessed.csv
master_info_with_nearby.csv
: File containing data with added information about nearby rental stations using master_info_with_nearby.ipynb
master_final.ipynb
: Processes rows where the district data has not been correctly recorded due to differences in address formatting
master_final.csv
: File containing data where 'stn_gu' has been appropriately added to all data using master_final.ipynb

stn_id : Represents the id of the rental station and is of object type
stn_addr : Represents the full address of the rental station and is of object type
stn_lat : Represents the latitude of the rental station and is of float64 type
stn_lng : Represents the longitude of the rental station and is of float64 type
nearby_id : Represents the id of the nearest rental station and is of object type
nearby_km : Represents the distance to the nearest rental station in km and is of float64 type
stn_gu : A district data column was added for analysis as the weather data classification is done by district. This is of object type