Bergen Bike Sharing Dataset (2023)

Explore trends in Bergen city bike usage by weather, location, and time. This dataset includes bike trips made between January 1 to December 31, 2023.

# Data Sources
- **Bike sharing data:** Bergen City Bike https://bergenbysykkel.no/en/open-data/historical
- Data licensed under the Norwegian Licence for Open Government Data (NLOD) 2.0.
- **Weather data:** Norwegian Center for Climate Services by The Norwegian Meteorological Institute (MET Norway) https://seklima.met.no/
- Weather symbol codes (from Yr.no): https://nrkno.github.io/yr-weather-symbols/
- Data licensed under the Norwegian Licence for Open Government Data (NLOD) 2.0 and Creative Commons 4.0 BY.
- **Public holidays in Norway:** https://publicholidays.no/2023-dates/

# Metadata
The data folder contains two CSV files.
- **bergen_merged.csv:** Original dataset merging Bergen bike sharing and weather data. Contains 467862 items. Contains 19 variables:
- `start_time`: Timestamp of when the trip started (YYYY-MM-DD HH:00:00)
- `end_time`: Timestamp of when the trip ended (YYYY-MM-DD HH:00:00)
- `duration`: Duration of trip (s)
- `start_station_id`: Unique ID of start station
- `start_station_name`: Name of start station
- `start_station_latitude`: Latitude of start station
- `start_station_longitude`: Longitude of start station
- `end_station_id`: Unique ID of end station
- `end_station_name`: Name of end station
- `end_station_latitude`: Latitude of end station
- `end_station_longitude`: Longitude of end station
- `precipitation`: Amount of precipitation per hour (mm)
- `temperature`: Air temperature at time of observation (°C)
- `wind_speed`: Maximum mean wind speed per hour (m/s)
- `weather`: Weather symbol code from Yr.no (0-50; see legend: https://nrkno.github.io/yr-weather-symbols/)
- `sunshine`: Sunshine duration per hour (min)
- `season`: Season code (0=Spring, 1=Summer, 2=Fall, 3=Winter)
- `is_holiday`: Public holiday in Norway
- `is_weekend`: Weekend - Saturday and Sunday
- **bergen_sampled.csv:** Lite version of the original dataset, suitable for visualization in Vega Altair. Contains 5000 items randomly sampled from May 01 - Dec 31 2023. Contains the same 19 variables as the original dataset.

# Data Processing
- **Bike sharing data:**
- Data from January - December 2023 were downloaded.
- Each item is a bike ride with a duration of at least one minute, made during Bergen City Bike regular opening hours (04:00-22:00).
- Start and end times were rounded down to the hour.
- **Weather data:**
- Data from January 01 - December 31 2023 were downloaded.
- Sunshine duration was taken from Flesland station.
- Precipitation, Air temperature, Maximum mean wind speed, and Weather symbol codes (from Yr.no) were taken from the Bergen-Florida station.
- Weather symbol code data was forward filled to cover missing values.
- Weather data is mapped to the start time of bike trip.

# License
Norwegian Licence for Open Government Data (NLOD) 2.0

Header image: Bergen Bysykkel

本数据集旨在探究伯根市自行车使用趋势，分析因素包括天气、地点和时间。数据集涵盖了2023年1月1日至12月31日期间发生的自行车行程。

# 数据来源

- **自行车共享数据：** 伯根市自行车（Bergen City Bike）
- 数据遵循挪威开放政府数据许可（NLOD）2.0。
- **天气数据：** 由挪威气象研究所（MET Norway）提供的挪威气候服务中心
- 天气符号代码（来自Yr.no）：https://nrkno.github.io/yr-weather-symbols/
- 数据遵循挪威开放政府数据许可（NLOD）2.0和Creative Commons 4.0 BY。
- **挪威公共假日：** https://publicholidays.no/2023-dates/

# 元数据
数据文件夹包含两个CSV文件。
- **bergen_merged.csv：** 将伯根市自行车共享数据和天气数据合并的原始数据集，包含467862条记录。包含19个变量：
- `start_time`：行程开始的时间戳（YYYY-MM-DD HH:00:00）
- `end_time`：行程结束的时间戳（YYYY-MM-DD HH:00:00）
- `duration`：行程时长（秒）
- `start_station_id`：起始站点的唯一ID
- `start_station_name`：起始站点的名称
- `start_station_latitude`：起始站点的纬度
- `start_station_longitude`：起始站点的经度
- `end_station_id`：终点站的唯一ID
- `end_station_name`：终点站点的名称
- `end_station_latitude`：终点站点的纬度
- `end_station_longitude`：终点站点的经度
- `precipitation`：每小时降水量（毫米）
- `temperature`：观测时的空气温度（°C）
- `wind_speed`：每小时最大平均风速（米/秒）
- `weather`：来自Yr.no的天气符号代码（0-50；见图例：https://nrkno.github.io/yr-weather-symbols/）
- `sunshine`：每小时日照时长（分钟）
- `season`：季节代码（0=春季，1=夏季，2=秋季，3=冬季）
- `is_holiday`：挪威公共假日
- `is_weekend`：周末——周六和周日
- **bergen_sampled.csv：** 原始数据集的简化版，适用于Vega Altair的可视化。从2023年5月1日至12月31日随机抽取了5000条记录。包含与原始数据集相同的19个变量。

# 数据处理
- **自行车共享数据：** 下载了2023年1月至12月的数据。
- 每个记录代表一次至少持续一分钟的骑行，且在伯根市自行车常规营业时间内（04:00-22:00）进行。
- 起始和结束时间被四舍五入到小时。
- **天气数据：** 下载了2023年1月1日至12月31日的数据。
- 日照时长来自弗莱士兰站。
- 降水量、空气温度、最大平均风速和天气符号代码（来自Yr.no）来自伯根-佛罗里达站。
- 天气符号代码数据进行了前向填充以覆盖缺失值。
- 天气数据与自行车行程的起始时间相对应。

# 许可
挪威开放政府数据许可（NLOD）2.0

页眉图片：Bergen Bysykkel