import pandas as pd
file_path = r"C:\Users\Hans\Desktop\data_analysis\test_data\Beijing_2014.csv"
df = pd.read_csv(file_path)
df.head()
|
Date |
Temperature(Celsius)(high) |
Temperature(Celsius)(avg) |
Temperature(Celsius)(low) |
Dew Point(Celsius)(high) |
Dew Point(Celsius)(avg) |
Dew Point(Celsius)(low) |
Humidity(%)(high) |
Humidity(%)(avg) |
Humidity(%)(low) |
... |
Visibility(km)(high) |
Visibility(km)(avg) |
Visibility(km)(low) |
Wind(km/h)(high) |
Wind(km/h)(avg) |
Precipitation(mm)(high) |
Precipitation(mm)(sum) |
weather1 |
weather2 |
weather3 |
0 |
2014-1-1 |
12 |
4 |
-2 |
-12 |
-17 |
-20 |
44 |
19 |
7 |
... |
31 |
11 |
5 |
32 |
16 |
47 |
0.0 |
NaN |
NaN |
NaN |
1 |
2014-1-2 |
7 |
0 |
-6 |
-6 |
-9 |
-13 |
74 |
50 |
28 |
... |
18 |
7 |
3 |
18 |
5 |
- |
0.0 |
NaN |
NaN |
NaN |
2 |
2014-1-3 |
9 |
3 |
-2 |
-7 |
-13 |
-18 |
64 |
32 |
9 |
... |
31 |
13 |
5 |
18 |
8 |
- |
0.0 |
NaN |
NaN |
NaN |
3 |
2014-1-4 |
2 |
-2 |
-6 |
-4 |
-7 |
-9 |
80 |
68 |
44 |
... |