Scribd
Upload
13 views29 pages

Weather Data Analysis Insights

Uploaded by

Omar Farooque
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views29 pages

Weather Data Analysis Insights

Uploaded by

Omar Farooque
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

4/6/24, 11:25 AM Weather Data Analysis

Exploratory Data Analysis of Weather Data

In [1]: import pandas as pd


import numpy as np
import [Link] as plt

In [2]: data= pd.read_csv(r"C:\Users\Hp\Desktop\1. Weather Data (1).csv")

data

In [4]: [Link]()

Out[4]: Dew
Rel Wind
Date/Time Temp_C Point Visibility_km Press_kPa Weather
Hum_% Speed_km/h
Temp_C

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

1/1/2012 Freezing
2 -1.8 -3.4 89 7 4.0 101.26
2:00 Drizzle,Fog

1/1/2012 Freezing
3 -1.5 -3.2 88 6 4.0 101.27
3:00 Drizzle,Fog

1/1/2012
4 -1.5 -3.3 88 7 4.8 101.23 Fog
4:00

In [6]: [Link]

[Link] Data Analysis (1).html 1/29


4/6/24, 11:25 AM Weather Data Analysis
(8784, 8)
Out[6]:

In [7]: [Link]

RangeIndex(start=0, stop=8784, step=1)


Out[7]:

In [8]: [Link]

Index(['Date/Time', 'Temp_C', 'Dew Point Temp_C', 'Rel Hum_%',


Out[8]:
'Wind Speed_km/h', 'Visibility_km', 'Press_kPa', 'Weather'],
dtype='object')

In [9]: [Link]

Date/Time object
Out[9]:
Temp_C float64
Dew Point Temp_C float64
Rel Hum_% int64
Wind Speed_km/h int64
Visibility_km float64
Press_kPa float64
Weather object
dtype: object

In [12]: data['Weather'].unique()

array(['Fog', 'Freezing Drizzle,Fog', 'Mostly Cloudy', 'Cloudy', 'Rain',


Out[12]:
'Rain Showers', 'Mainly Clear', 'Snow Showers', 'Snow', 'Clear',
'Freezing Rain,Fog', 'Freezing Rain', 'Freezing Drizzle',
'Rain,Snow', 'Moderate Snow', 'Freezing Drizzle,Snow',
'Freezing Rain,Snow Grains', 'Snow,Blowing Snow', 'Freezing Fog',
'Haze', 'Rain,Fog', 'Drizzle,Fog', 'Drizzle',
'Freezing Drizzle,Haze', 'Freezing Rain,Haze', 'Snow,Haze',
'Snow,Fog', 'Snow,Ice Pellets', 'Rain,Haze', 'Thunderstorms,Rain',
'Thunderstorms,Rain Showers', 'Thunderstorms,Heavy Rain Showers',
'Thunderstorms,Rain Showers,Fog', 'Thunderstorms',
'Thunderstorms,Rain,Fog',
'Thunderstorms,Moderate Rain Showers,Fog', 'Rain Showers,Fog',
'Rain Showers,Snow Showers', 'Snow Pellets', 'Rain,Snow,Fog',
'Moderate Rain,Fog', 'Freezing Rain,Ice Pellets,Fog',
'Drizzle,Ice Pellets,Fog', 'Drizzle,Snow', 'Rain,Ice Pellets',
'Drizzle,Snow,Fog', 'Rain,Snow Grains', 'Rain,Snow,Ice Pellets',
'Snow Showers,Fog', 'Moderate Snow,Blowing Snow'], dtype=object)

In [13]: [Link]()

Date/Time 8784
Out[13]:
Temp_C 533
Dew Point Temp_C 489
Rel Hum_% 83
Wind Speed_km/h 34
Visibility_km 24
Press_kPa 518
Weather 50
dtype: int64

In [14]: [Link]()

[Link] Data Analysis (1).html 2/29


4/6/24, 11:25 AM Weather Data Analysis
Date/Time 8784
Out[14]:
Temp_C 8784
Dew Point Temp_C 8784
Rel Hum_% 8784
Wind Speed_km/h 8784
Visibility_km 8784
Press_kPa 8784
Weather 8784
dtype: int64

In [17]: data['Weather'].value_counts()

[Link] Data Analysis (1).html 3/29


4/6/24, 11:25 AM Weather Data Analysis
Mainly Clear 2106
Out[17]:
Mostly Cloudy 2069
Cloudy 1728
Clear 1326
Snow 390
Rain 306
Rain Showers 188
Fog 150
Rain,Fog 116
Drizzle,Fog 80
Snow Showers 60
Drizzle 41
Snow,Fog 37
Snow,Blowing Snow 19
Rain,Snow 18
Thunderstorms,Rain Showers 16
Haze 16
Drizzle,Snow,Fog 15
Freezing Rain 14
Freezing Drizzle,Snow 11
Freezing Drizzle 7
Snow,Ice Pellets 6
Freezing Drizzle,Fog 6
Snow,Haze 5
Freezing Fog 4
Snow Showers,Fog 4
Moderate Snow 4
Rain,Snow,Ice Pellets 4
Freezing Rain,Fog 4
Freezing Drizzle,Haze 3
Rain,Haze 3
Thunderstorms,Rain 3
Thunderstorms,Rain Showers,Fog 3
Freezing Rain,Haze 2
Drizzle,Snow 2
Rain Showers,Snow Showers 2
Thunderstorms 2
Moderate Snow,Blowing Snow 2
Rain Showers,Fog 1
Thunderstorms,Moderate Rain Showers,Fog 1
Snow Pellets 1
Rain,Snow,Fog 1
Moderate Rain,Fog 1
Freezing Rain,Ice Pellets,Fog 1
Drizzle,Ice Pellets,Fog 1
Thunderstorms,Rain,Fog 1
Rain,Ice Pellets 1
Rain,Snow Grains 1
Thunderstorms,Heavy Rain Showers 1
Freezing Rain,Snow Grains 1
Name: Weather, dtype: int64

In [18]: [Link]()

[Link] Data Analysis (1).html 4/29


4/6/24, 11:25 AM Weather Data Analysis
<class '[Link]'>
RangeIndex: 8784 entries, 0 to 8783
Data columns (total 8 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 Date/Time 8784 non-null object
1 Temp_C 8784 non-null float64
2 Dew Point Temp_C 8784 non-null float64
3 Rel Hum_% 8784 non-null int64
4 Wind Speed_km/h 8784 non-null int64
5 Visibility_km 8784 non-null float64
6 Press_kPa 8784 non-null float64
7 Weather 8784 non-null object
dtypes: float64(4), int64(2), object(2)
memory usage: 549.1+ KB

In [19]: #1. find all Wind speed unique value in data

In [20]: [Link](2)

Out[20]: Dew Point Rel Wind


Date/Time Temp_C Visibility_km Press_kPa Weather
Temp_C Hum_% Speed_km/h

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

In [21]: [Link]()

Date/Time 8784
Out[21]:
Temp_C 533
Dew Point Temp_C 489
Rel Hum_% 83
Wind Speed_km/h 34
Visibility_km 24
Press_kPa 518
Weather 50
dtype: int64

In [22]: data['Wind Speed_km/h'].nunique()

34
Out[22]:

In [23]: data['Wind Speed_km/h'].unique() #Answer

array([ 4, 7, 6, 9, 15, 13, 20, 22, 19, 24, 30, 35, 39, 32, 33, 26, 44,
Out[23]:
43, 48, 37, 28, 17, 11, 0, 83, 70, 57, 46, 41, 52, 50, 63, 54, 2],
dtype=int64)

In [ ]: ### find the number of time when the 'Weather is Clear

In [24]: [Link](2)

[Link] Data Analysis (1).html 5/29


4/6/24, 11:25 AM Weather Data Analysis

Out[24]: Dew Point Rel Wind


Date/Time Temp_C Visibility_km Press_kPa Weather
Temp_C Hum_% Speed_km/h

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

In [25]: data['Weather'].value_counts() #value_counts Method 1

[Link] Data Analysis (1).html 6/29


4/6/24, 11:25 AM Weather Data Analysis
Mainly Clear 2106
Out[25]:
Mostly Cloudy 2069
Cloudy 1728
Clear 1326
Snow 390
Rain 306
Rain Showers 188
Fog 150
Rain,Fog 116
Drizzle,Fog 80
Snow Showers 60
Drizzle 41
Snow,Fog 37
Snow,Blowing Snow 19
Rain,Snow 18
Thunderstorms,Rain Showers 16
Haze 16
Drizzle,Snow,Fog 15
Freezing Rain 14
Freezing Drizzle,Snow 11
Freezing Drizzle 7
Snow,Ice Pellets 6
Freezing Drizzle,Fog 6
Snow,Haze 5
Freezing Fog 4
Snow Showers,Fog 4
Moderate Snow 4
Rain,Snow,Ice Pellets 4
Freezing Rain,Fog 4
Freezing Drizzle,Haze 3
Rain,Haze 3
Thunderstorms,Rain 3
Thunderstorms,Rain Showers,Fog 3
Freezing Rain,Haze 2
Drizzle,Snow 2
Rain Showers,Snow Showers 2
Thunderstorms 2
Moderate Snow,Blowing Snow 2
Rain Showers,Fog 1
Thunderstorms,Moderate Rain Showers,Fog 1
Snow Pellets 1
Rain,Snow,Fog 1
Moderate Rain,Fog 1
Freezing Rain,Ice Pellets,Fog 1
Drizzle,Ice Pellets,Fog 1
Thunderstorms,Rain,Fog 1
Rain,Ice Pellets 1
Rain,Snow Grains 1
Thunderstorms,Heavy Rain Showers 1
Freezing Rain,Snow Grains 1
Name: Weather, dtype: int64

In [35]: #filtering
[Link](2)

[Link] Data Analysis (1).html 7/29


4/6/24, 11:25 AM Weather Data Analysis

Out[35]: Dew Point Rel Wind


Date/Time Temp_C Visibility_km Press_kPa Weather
Temp_C Hum_% Speed_km/h

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

In [36]: data[[Link] == 'clear']

Out[36]: Dew Point Rel Wind


Date/Time Temp_C Visibility_km Press_kPa Weather
Temp_C Hum_% Speed_km/h

In [37]: [Link](2)

Out[37]: Dew Point Rel Wind


Date/Time Temp_C Visibility_km Press_kPa Weather
Temp_C Hum_% Speed_km/h

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

In [ ]: #Find the number of times when the wind speed was exactly the same as 4km/hr

In [42]: [Link](2)

Out[42]: Dew Point Rel Wind


Date/Time Temp_C Visibility_km Press_kPa Weather
Temp_C Hum_% Speed_km/h

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

In [44]: data[data['Wind Speed_km/h'] == 4] #Answer

[Link] Data Analysis (1).html 8/29


4/6/24, 11:25 AM Weather Data Analysis

Out[44]: Dew
Rel Wind
Date/Time Temp_C Point Visibility_km Press_kPa Weather
Hum_% Speed_km/h
Temp_C

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

1/5/2012
96 -8.8 -11.7 79 4 9.7 100.32 Snow
0:00

1/5/2012
101 -7.0 -9.5 82 4 4.0 100.19 Snow
5:00

1/7/2012
146 -8.1 -11.1 79 4 19.3 100.15 Cloudy
2:00

... ... ... ... ... ... ... ... ...

12/31/2012 Snow
8768 -8.6 -10.3 87 4 3.2 101.14
8:00 Showers

12/31/2012
8769 -8.1 -9.6 89 4 2.4 101.09 Snow
9:00

12/31/2012
8770 -7.4 -8.9 89 4 6.4 101.05 Snow,Fog
10:00

12/31/2012
8772 -5.8 -7.5 88 4 12.9 100.78 Snow
12:00

12/31/2012
8773 -4.6 -6.6 86 4 12.9 100.63 Snow
13:00

474 rows × 8 columns

In [45]: #Find the number of null values in the data

In [ ]: [Link](2)

In [47]: [Link]().sum()

Date/Time 0
Out[47]:
Temp_C 0
Dew Point Temp_C 0
Rel Hum_% 0
Wind Speed_km/h 0
Visibility_km 0
Press_kPa 0
Weather 0
dtype: int64

In [49]: [Link]().sum()

[Link] Data Analysis (1).html 9/29


4/6/24, 11:25 AM Weather Data Analysis
Date/Time 8784
Out[49]:
Temp_C 8784
Dew Point Temp_C 8784
Rel Hum_% 8784
Wind Speed_km/h 8784
Visibility_km 8784
Press_kPa 8784
Weather 8784
dtype: int64

In [50]: #rename the coloumn name 'weather' of dataframe to weather condition

In [52]: [Link](2)

Out[52]: Dew Point Rel Wind


Date/Time Temp_C Visibility_km Press_kPa Weather
Temp_C Hum_% Speed_km/h

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

In [63]: [Link](columns = {'Weather' : 'Weather condition'})

[Link] Data Analysis (1).html 10/29


4/6/24, 11:25 AM Weather Data Analysis

Out[63]: Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

1/1/2012 Freezing
2 -1.8 -3.4 89 7 4.0 101.26
2:00 Drizzle,Fog

1/1/2012 Freezing
3 -1.5 -3.2 88 6 4.0 101.27
3:00 Drizzle,Fog

1/1/2012
4 -1.5 -3.3 88 7 4.8 101.23 Fog
4:00

... ... ... ... ... ... ... ... ...

12/31/2012
8779 0.1 -2.7 81 30 9.7 100.13 Snow
19:00

12/31/2012
8780 0.2 -2.4 83 24 9.7 100.03 Snow
20:00

12/31/2012
8781 -0.5 -1.5 93 28 4.8 99.95 Snow
21:00

12/31/2012
8782 -0.2 -1.8 89 28 9.7 99.91 Snow
22:00

12/31/2012
8783 0.0 -2.1 86 30 11.3 99.89 Snow
23:00

8784 rows × 8 columns

In [57]: #[Link]()

In [64]: [Link](columns = {'Weather' : 'Weather condition'}, inplace= True)

In [65]: [Link]()

[Link] Data Analysis (1).html 11/29


4/6/24, 11:25 AM Weather Data Analysis

Out[65]: Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

1/1/2012 Freezing
2 -1.8 -3.4 89 7 4.0 101.26
2:00 Drizzle,Fog

1/1/2012 Freezing
3 -1.5 -3.2 88 6 4.0 101.27
3:00 Drizzle,Fog

1/1/2012
4 -1.5 -3.3 88 7 4.8 101.23 Fog
4:00

In [66]: # What is Mean Visibility?

In [68]: [Link](2)

Out[68]: Dew Point Rel Wind Weather


Date/Time Temp_C Visibility_km Press_kPa
Temp_C Hum_% Speed_km/h condition

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

In [69]: data.Visibility_km.mean()

27.66444672131151
Out[69]:

In [70]: #what is standard deviation of 'pressure' in this data?

In [71]: data.Press_kPa.std()

0.8440047459486474
Out[71]:

In [72]: #what is the variance of relative humidity in this area?

In [74]: data['Rel Hum_%'].var()

286.2485501984998
Out[74]:

In [75]: #find all the instances where 'snow' was recorded?

In [76]: [Link]()

[Link] Data Analysis (1).html 12/29


4/6/24, 11:25 AM Weather Data Analysis

Out[76]: Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

1/1/2012 Freezing
2 -1.8 -3.4 89 7 4.0 101.26
2:00 Drizzle,Fog

1/1/2012 Freezing
3 -1.5 -3.2 88 6 4.0 101.27
3:00 Drizzle,Fog

1/1/2012
4 -1.5 -3.3 88 7 4.8 101.23 Fog
4:00

In [77]: data['Weather condition'].value_counts()

[Link] Data Analysis (1).html 13/29


4/6/24, 11:25 AM Weather Data Analysis
Mainly Clear 2106
Out[77]:
Mostly Cloudy 2069
Cloudy 1728
Clear 1326
Snow 390
Rain 306
Rain Showers 188
Fog 150
Rain,Fog 116
Drizzle,Fog 80
Snow Showers 60
Drizzle 41
Snow,Fog 37
Snow,Blowing Snow 19
Rain,Snow 18
Thunderstorms,Rain Showers 16
Haze 16
Drizzle,Snow,Fog 15
Freezing Rain 14
Freezing Drizzle,Snow 11
Freezing Drizzle 7
Snow,Ice Pellets 6
Freezing Drizzle,Fog 6
Snow,Haze 5
Freezing Fog 4
Snow Showers,Fog 4
Moderate Snow 4
Rain,Snow,Ice Pellets 4
Freezing Rain,Fog 4
Freezing Drizzle,Haze 3
Rain,Haze 3
Thunderstorms,Rain 3
Thunderstorms,Rain Showers,Fog 3
Freezing Rain,Haze 2
Drizzle,Snow 2
Rain Showers,Snow Showers 2
Thunderstorms 2
Moderate Snow,Blowing Snow 2
Rain Showers,Fog 1
Thunderstorms,Moderate Rain Showers,Fog 1
Snow Pellets 1
Rain,Snow,Fog 1
Moderate Rain,Fog 1
Freezing Rain,Ice Pellets,Fog 1
Drizzle,Ice Pellets,Fog 1
Thunderstorms,Rain,Fog 1
Rain,Ice Pellets 1
Rain,Snow Grains 1
Thunderstorms,Heavy Rain Showers 1
Freezing Rain,Snow Grains 1
Name: Weather condition, dtype: int64

In [79]: #filtering
data[data['Weather condition'] == 'Snow']

[Link] Data Analysis (1).html 14/29


4/6/24, 11:25 AM Weather Data Analysis

Out[79]: Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C

1/3/2012
55 -14.0 -19.5 63 19 25.0 100.95 Snow
7:00

1/4/2012
84 -13.7 -21.7 51 11 24.1 101.25 Snow
12:00

1/4/2012
86 -11.3 -19.0 53 7 19.3 100.97 Snow
14:00

1/4/2012
87 -10.2 -16.3 61 11 9.7 100.89 Snow
15:00

1/4/2012
88 -9.4 -15.5 61 13 19.3 100.79 Snow
16:00

... ... ... ... ... ... ... ... ...

12/31/2012
8779 0.1 -2.7 81 30 9.7 100.13 Snow
19:00

12/31/2012
8780 0.2 -2.4 83 24 9.7 100.03 Snow
20:00

12/31/2012
8781 -0.5 -1.5 93 28 4.8 99.95 Snow
21:00

12/31/2012
8782 -0.2 -1.8 89 28 9.7 99.91 Snow
22:00

12/31/2012
8783 0.0 -2.1 86 30 11.3 99.89 Snow
23:00

390 rows × 8 columns

In [84]: #string contains


data[data['Weather condition'].[Link]('Snow')].head(50)

[Link] Data Analysis (1).html 15/29


4/6/24, 11:25 AM Weather Data Analysis

Out[84]: Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C

1/2/2012 Snow
41 -2.1 -9.5 57 22 25.0 99.66
17:00 Showers

1/2/2012 Snow
44 -5.6 -13.4 54 24 25.0 100.07
20:00 Showers

1/2/2012 Snow
45 -5.8 -12.8 58 26 25.0 100.15
21:00 Showers

1/2/2012 Snow
47 -7.4 -14.1 59 17 19.3 100.27
23:00 Showers

1/3/2012 Snow
48 -9.0 -16.0 57 28 25.0 100.35
0:00 Showers

1/3/2012 Snow
50 -10.5 -15.8 65 22 12.9 100.53
2:00 Showers

1/3/2012 Snow
51 -11.3 -18.7 54 33 25.0 100.61
3:00 Showers

1/3/2012 Snow
53 -12.9 -19.1 60 22 25.0 100.76
5:00 Showers

1/3/2012 Snow
54 -13.3 -19.3 61 19 25.0 100.85
6:00 Showers

1/3/2012
55 -14.0 -19.5 63 19 25.0 100.95 Snow
7:00

1/4/2012
84 -13.7 -21.7 51 11 24.1 101.25 Snow
12:00

1/4/2012
86 -11.3 -19.0 53 7 19.3 100.97 Snow
14:00

1/4/2012
87 -10.2 -16.3 61 11 9.7 100.89 Snow
15:00

1/4/2012
88 -9.4 -15.5 61 13 19.3 100.79 Snow
16:00

1/4/2012
89 -8.9 -13.2 71 9 4.8 100.76 Snow
17:00

1/4/2012
90 -8.9 -12.6 75 11 9.7 100.69 Snow
18:00

1/4/2012
91 -8.4 -12.7 71 9 16.1 100.65 Snow
19:00

1/4/2012
92 -7.8 -12.1 71 9 16.1 100.61 Snow
20:00

1/4/2012
93 -7.6 -11.6 73 7 11.3 100.54 Snow
21:00

1/4/2012
94 -9.5 -12.7 77 6 9.7 100.50 Snow
22:00

95 1/4/2012 -9.6 -12.6 79 6 9.7 100.42 Snow

[Link] Data Analysis (1).html 16/29


4/6/24, 11:25 AM Weather Data Analysis

Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C
23:00

1/5/2012
96 -8.8 -11.7 79 4 9.7 100.32 Snow
0:00

1/5/2012
97 -7.5 -10.2 81 0 9.7 100.29 Snow
1:00

1/5/2012
98 -5.4 -8.3 80 9 8.0 100.28 Snow
2:00

1/5/2012
99 -5.0 -7.7 81 11 9.7 100.24 Snow
3:00

1/5/2012
100 -4.1 -6.5 83 9 4.8 100.21 Snow
4:00

1/5/2012
101 -7.0 -9.5 82 4 4.0 100.19 Snow
5:00

1/5/2012
102 -8.2 -10.7 82 6 6.4 100.26 Snow
6:00

1/5/2012
103 -7.1 -9.7 82 9 9.7 100.31 Snow
7:00

1/5/2012
104 -6.1 -9.1 79 11 9.7 100.39 Snow
8:00

1/6/2012
123 -10.6 -16.0 64 0 9.7 100.76 Snow
3:00

1/6/2012
124 -11.3 -16.1 68 15 3.2 100.70 Snow
4:00

1/6/2012
125 -11.8 -16.0 71 19 2.8 100.61 Snow
5:00

1/6/2012
126 -12.0 -16.2 71 22 4.8 100.58 Snow
6:00

1/6/2012
127 -14.4 -16.3 85 22 2.4 100.52 Snow
7:00

1/6/2012
128 -12.3 -16.2 73 24 11.3 100.51 Snow
8:00

1/6/2012
129 -12.5 -16.7 71 26 19.3 100.53 Snow
9:00

1/6/2012
130 -12.3 -16.3 72 28 16.1 100.47 Snow
10:00

1/6/2012
131 -12.0 -16.0 72 17 24.1 100.36 Snow
11:00

1/6/2012
132 -11.7 -15.4 74 28 19.3 100.23 Snow
12:00

1/6/2012
133 -11.9 -15.6 74 20 24.1 100.13 Snow
13:00

[Link] Data Analysis (1).html 17/29


4/6/24, 11:25 AM Weather Data Analysis

Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C

1/6/2012
134 -11.2 -14.8 75 19 19.3 100.07 Snow
14:00

1/6/2012
135 -11.5 -14.4 79 19 12.9 100.06 Snow
15:00

1/6/2012
136 -11.6 -14.7 78 19 19.3 100.10 Snow
16:00

1/6/2012
137 -11.2 -14.3 78 17 25.0 100.15 Snow
17:00

1/7/2012
158 -4.4 -6.9 83 6 8.0 100.09 Snow
14:00

1/7/2012
159 -3.7 -6.1 83 11 8.0 100.09 Snow
15:00

1/7/2012
160 -3.6 -5.9 84 0 8.0 100.15 Snow
16:00

1/7/2012
161 -3.1 -5.4 84 13 8.0 100.27 Snow
17:00

1/7/2012
162 -3.2 -5.3 85 6 9.7 100.33 Snow
18:00

In [ ]: #find all the instances when wind speed is above 24 and visibility is 25?

In [85]: [Link](2)

Out[85]: Dew Point Rel Wind Weather


Date/Time Temp_C Visibility_km Press_kPa
Temp_C Hum_% Speed_km/h condition

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

In [90]: data[(data['Wind Speed_km/h'] > 24) & (data['Visibility_km'] == 25)]

[Link] Data Analysis (1).html 18/29


4/6/24, 11:25 AM Weather Data Analysis

Out[90]: Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C

1/1/2012
23 5.3 2.0 79 30 25.0 99.31 Cloudy
23:00

1/2/2012 Rain
24 5.2 1.5 77 35 25.0 99.26
0:00 Showers

1/2/2012
25 4.6 0.0 72 39 25.0 99.26 Cloudy
1:00

1/2/2012 Mostly
26 3.9 -0.9 71 32 25.0 99.26
2:00 Cloudy

1/2/2012 Mostly
27 3.7 -1.5 69 33 25.0 99.30
3:00 Cloudy

... ... ... ... ... ... ... ... ...

12/28/2012 Mainly
8705 -8.6 -12.0 76 26 25.0 101.34
17:00 Clear

12/30/2012 Mainly
8753 -12.1 -15.8 74 28 25.0 101.26
17:00 Clear

12/30/2012 Mainly
8755 -13.4 -16.5 77 26 25.0 101.47
19:00 Clear

12/30/2012 Mostly
8759 -12.1 -15.1 78 28 25.0 101.52
23:00 Cloudy

12/31/2012
8760 -11.1 -14.4 77 26 25.0 101.51 Cloudy
0:00

308 rows × 8 columns

In [ ]: #what is the mean vlaue of each coloumn against 'Waether condition'?

In [91]: [Link]('Weather condition').mean()

[Link] Data Analysis (1).html 19/29


4/6/24, 11:25 AM Weather Data Analysis

Out[91]: Dew Point Rel Wind


Temp_C Visibility_km Press_kPa
Temp_C Hum_% Speed_km/h

Weather condition

Clear 6.825716 0.089367 64.497738 10.557315 30.153243 101.587443

Cloudy 7.970544 2.375810 69.592593 16.127315 26.625752 100.911441

Drizzle 7.353659 5.504878 88.243902 16.097561 17.931707 100.435366

Drizzle,Fog 8.067500 7.033750 93.275000 11.862500 5.257500 100.786625

Drizzle,Ice Pellets,Fog 0.400000 -0.700000 92.000000 20.000000 4.000000 100.790000

Drizzle,Snow 1.050000 0.150000 93.500000 14.000000 10.500000 100.890000

Drizzle,Snow,Fog 0.693333 0.120000 95.866667 15.533333 5.513333 99.281333

Fog 4.303333 3.159333 92.286667 7.946667 6.248000 101.184067

Freezing Drizzle -5.657143 -8.000000 83.571429 16.571429 9.200000 100.202857

Freezing Drizzle,Fog -2.533333 -4.183333 88.500000 17.000000 5.266667 100.441667

Freezing Drizzle,Haze -5.433333 -8.000000 82.000000 10.333333 2.666667 100.316667

Freezing Drizzle,Snow -5.109091 -7.072727 86.090909 16.272727 5.872727 100.520909

Freezing Fog -7.575000 -9.250000 87.750000 4.750000 0.650000 102.320000

Freezing Rain -3.885714 -6.078571 84.642857 19.214286 8.242857 99.647143

Freezing Rain,Fog -2.225000 -3.750000 89.500000 15.500000 7.550000 99.945000

Freezing Rain,Haze -4.900000 -7.450000 82.500000 7.500000 2.400000 100.375000

Freezing Rain,Ice
-2.600000 -3.700000 92.000000 28.000000 8.000000 100.950000
Pellets,Fog

Freezing Rain,Snow
-5.000000 -7.300000 84.000000 32.000000 4.800000 98.560000
Grains

Haze -0.200000 -2.975000 81.625000 10.437500 7.831250 101.482500

Mainly Clear 12.558927 4.581671 60.667142 14.144824 34.264862 101.248832

Moderate Rain,Fog 1.700000 0.800000 94.000000 17.000000 6.400000 99.980000

Moderate Snow -5.525000 -7.250000 87.750000 33.750000 0.750000 100.275000

Moderate Snow,Blowing
-5.450000 -6.500000 92.500000 40.000000 0.600000 100.570000
Snow

Mostly Cloudy 10.574287 3.131174 62.102465 15.813920 31.253842 101.025288

Rain 9.786275 7.042810 83.624183 19.254902 18.856536 100.233333

Rain Showers 13.722340 9.187766 75.159574 17.132979 22.816489 100.404043

Rain Showers,Fog 12.800000 12.100000 96.000000 13.000000 6.400000 99.830000

Rain Showers,Snow
2.150000 -1.500000 76.500000 22.500000 21.700000 101.100000
Showers

Rain,Fog 8.273276 7.219828 93.189655 14.793103 6.873276 100.500862

Rain,Haze 4.633333 2.066667 83.333333 11.666667 6.700000 100.540000

[Link] Data Analysis (1).html 20/29


4/6/24, 11:25 AM Weather Data Analysis

Dew Point Rel Wind


Temp_C Visibility_km Press_kPa
Temp_C Hum_% Speed_km/h

Weather condition

Rain,Ice Pellets 0.600000 -0.600000 92.000000 24.000000 9.700000 100.120000

Rain,Snow 1.055556 -0.566667 89.000000 28.388889 11.672222 99.951111

Rain,Snow Grains 1.900000 -2.100000 75.000000 26.000000 25.000000 100.600000

Rain,Snow,Fog 0.800000 0.300000 96.000000 9.000000 6.400000 100.730000

Rain,Snow,Ice Pellets 1.100000 -0.175000 91.500000 23.250000 6.000000 100.105000

Snow -4.524103 -7.623333 79.307692 20.038462 11.171795 100.536103

Snow Pellets 0.700000 -6.400000 59.000000 35.000000 2.400000 99.700000

Snow Showers -3.506667 -7.866667 72.350000 19.233333 20.158333 100.963500

Snow Showers,Fog -10.675000 -11.900000 90.750000 13.750000 7.025000 101.292500

Snow,Blowing Snow -5.410526 -7.621053 84.473684 34.842105 4.105263 99.704737

Snow,Fog -5.075676 -6.364865 90.675676 17.324324 4.537838 100.688649

Snow,Haze -4.020000 -6.860000 80.600000 5.000000 4.640000 100.782000

Snow,Ice Pellets -1.883333 -3.666667 87.666667 23.833333 7.416667 100.548333

Thunderstorms 24.150000 19.750000 77.000000 7.500000 24.550000 100.230000

Thunderstorms,Heavy
10.900000 9.000000 88.000000 9.000000 2.400000 100.260000
Rain Showers

Thunderstorms,Moderate
19.600000 18.500000 93.000000 15.000000 3.200000 100.010000
Rain Showers,Fog

Thunderstorms,Rain 20.433333 18.533333 89.000000 15.666667 19.833333 100.420000

Thunderstorms,Rain
20.037500 17.618750 86.375000 18.312500 15.893750 100.233750
Showers

Thunderstorms,Rain
21.600000 18.700000 84.000000 19.666667 9.700000 100.063333
Showers,Fog

Thunderstorms,Rain,Fog 20.600000 18.600000 88.000000 19.000000 4.800000 100.080000

In [92]: # what is thr min and Maximum value of Weather condition?

In [93]: [Link]()

[Link] Data Analysis (1).html 21/29


4/6/24, 11:25 AM Weather Data Analysis

Out[93]: Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

1/1/2012 Freezing
2 -1.8 -3.4 89 7 4.0 101.26
2:00 Drizzle,Fog

1/1/2012 Freezing
3 -1.5 -3.2 88 6 4.0 101.27
3:00 Drizzle,Fog

1/1/2012
4 -1.5 -3.3 88 7 4.8 101.23 Fog
4:00

In [94]: [Link]('Weather condition').min()

[Link] Data Analysis (1).html 22/29


4/6/24, 11:25 AM Weather Data Analysis

Out[94]: Dew
Rel Wind
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h
Temp_C

Weather condition

1/11/2012
Clear -23.3 -28.5 20 0 11.3 99.52
1:00

1/1/2012
Cloudy -21.4 -26.8 18 0 11.3 98.39
17:00

1/23/2012
Drizzle 1.1 -0.2 74 0 6.4 97.84
21:00

1/23/2012
Drizzle,Fog 0.0 -1.6 85 0 1.0 98.65
20:00

12/17/2012
Drizzle,Ice Pellets,Fog 0.4 -0.7 92 20 4.0 100.79
9:00

12/17/2012
Drizzle,Snow 0.9 0.1 92 9 9.7 100.63
15:00

12/18/2012
Drizzle,Snow,Fog 0.3 -0.1 92 7 2.4 97.79
21:00

1/1/2012
Fog -16.0 -17.2 80 0 0.2 98.31
0:00

1/13/2012
Freezing Drizzle -9.0 -12.2 78 6 4.8 98.44
10:00

1/1/2012
Freezing Drizzle,Fog -6.4 -9.0 82 6 3.6 98.74
2:00

2/1/2012
Freezing Drizzle,Haze -5.8 -8.3 81 9 2.0 100.28
11:00

1/13/2012
Freezing Drizzle,Snow -8.3 -10.4 79 6 2.4 99.19
3:00

1/22/2012
Freezing Fog -19.0 -22.9 71 0 0.2 101.97
6:00

1/13/2012
Freezing Rain -6.5 -9.0 81 7 2.8 98.22
11:00

1/17/2012
Freezing Rain,Fog -6.1 -8.7 82 7 2.8 98.32
23:00

2/1/2012
Freezing Rain,Haze -4.9 -7.5 82 6 2.0 100.34
14:00

Freezing Rain,Ice 12/17/2012


-2.6 -3.7 92 28 8.0 100.95
Pellets,Fog 3:00

Freezing Rain,Snow 1/13/2012


-5.0 -7.3 84 32 4.8 98.56
Grains 9:00

1/22/2012
Haze -11.5 -16.0 68 0 4.8 100.35
12:00

1/10/2012
Mainly Clear -22.8 -28.0 20 0 12.9 98.67
11:00

[Link] Data Analysis (1).html 23/29


4/6/24, 11:25 AM Weather Data Analysis

Dew
Rel Wind
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h
Temp_C

Weather condition

12/10/2012
Moderate Rain,Fog 1.7 0.8 94 17 6.4 99.98
8:00

1/12/2012
Moderate Snow -6.3 -7.6 83 26 0.6 99.88
15:00

Moderate Snow,Blowing 12/27/2012


-5.5 -6.6 92 39 0.6 100.50
Snow 10:00

1/1/2012
Mostly Cloudy -23.2 -28.5 18 0 11.3 98.36
16:00

1/1/2012
Rain 0.3 -5.7 40 0 4.0 97.52
18:00

1/1/2012
Rain Showers 1.6 -7.2 37 0 6.4 98.51
22:00

10/20/2012
Rain Showers,Fog 12.8 12.1 96 13 6.4 99.83
3:00

Rain Showers,Snow 11/4/2012


2.1 -1.8 75 17 19.3 101.09
Showers 8:00

1/23/2012
Rain,Fog 0.0 -1.2 83 0 2.0 98.61
18:00

3/13/2012
Rain,Haze 4.0 1.0 81 7 4.0 100.50
7:00

12/18/2012
Rain,Ice Pellets 0.6 -0.6 92 24 9.7 100.12
5:00

1/10/2012
Rain,Snow 0.6 -1.7 81 13 2.4 98.18
5:00

12/21/2012
Rain,Snow Grains 1.9 -2.1 75 26 25.0 100.60
0:00

12/8/2012
Rain,Snow,Fog 0.8 0.3 96 9 6.4 100.73
21:00

12/21/2012
Rain,Snow,Ice Pellets 0.9 -0.7 88 17 4.8 99.85
1:00

1/10/2012
Snow -16.7 -24.6 41 0 1.0 97.75
1:00

11/24/2012
Snow Pellets 0.7 -6.4 59 35 2.4 99.70
15:00

1/12/2012
Snow Showers -13.3 -19.3 52 0 2.4 99.49
7:00

12/26/2012
Snow Showers,Fog -11.3 -12.7 89 7 4.0 100.63
9:00

1/13/2012
Snow,Blowing Snow -12.0 -16.2 70 24 0.6 98.11
21:00

[Link] Data Analysis (1).html 24/29


4/6/24, 11:25 AM Weather Data Analysis

Dew
Rel Wind
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h
Temp_C

Weather condition

12/16/2012
Snow,Fog -10.1 -12.0 77 4 1.2 99.38
15:00

2/1/2012
Snow,Haze -4.3 -7.2 80 0 4.0 100.61
17:00

12/10/2012
Snow,Ice Pellets -4.3 -5.9 76 19 2.8 99.40
3:00

7/16/2012
Thunderstorms 21.6 19.4 67 0 24.1 99.84
1:00

Thunderstorms,Heavy 5/29/2012
10.9 9.0 88 9 2.4 100.26
Rain Showers 6:00

Thunderstorms,Moderate 7/17/2012
19.6 18.5 93 15 3.2 100.01
Rain Showers,Fog 6:00

5/25/2012
Thunderstorms,Rain 19.4 18.2 83 4 16.1 100.19
20:00

Thunderstorms,Rain 5/29/2012
11.0 7.0 68 7 6.4 99.65
Showers 16:00

Thunderstorms,Rain 6/29/2012
19.5 16.1 80 7 9.7 99.71
Showers,Fog 3:00

7/17/2012
Thunderstorms,Rain,Fog 20.6 18.6 88 19 4.8 100.08
5:00

In [95]: [Link]('Weather condition').max()

[Link] Data Analysis (1).html 25/29


4/6/24, 11:25 AM Weather Data Analysis

Out[95]: Dew
Rel Wind
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h
Temp_C

Weather condition

9/9/2012
Clear 32.8 20.4 99 33 48.3 103.63
5:00

9/9/2012
Cloudy 30.5 22.6 99 54 48.3 103.65
23:00

9/30/2012
Drizzle 18.8 17.7 96 30 25.0 101.56
3:00

9/30/2012
Drizzle,Fog 19.9 19.1 100 28 9.7 102.07
2:00

12/17/2012
Drizzle,Ice Pellets,Fog 0.4 -0.7 92 20 4.0 100.79
9:00

12/19/2012
Drizzle,Snow 1.2 0.2 95 19 11.3 101.15
18:00

12/22/2012
Drizzle,Snow,Fog 1.1 0.6 98 32 9.7 100.15
3:00

9/22/2012
Fog 20.8 19.6 100 22 9.7 103.04
0:00

2/1/2012
Freezing Drizzle -2.3 -3.3 93 26 12.9 101.02
5:00

12/10/2012
Freezing Drizzle,Fog -0.3 -2.3 94 33 8.0 101.27
5:00

2/1/2012
Freezing Drizzle,Haze -5.0 -7.7 83 11 4.0 100.36
13:00

3/2/2012
Freezing Drizzle,Snow -3.3 -4.6 94 24 12.9 101.18
12:00

3/17/2012
Freezing Fog -0.1 -0.3 99 9 0.8 102.85
6:00

2/1/2012
Freezing Rain 0.3 -1.7 92 28 16.1 101.00
7:00

12/17/2012
Freezing Rain,Fog 0.1 -0.9 93 26 9.7 101.01
1:00

2/1/2012
Freezing Rain,Haze -4.9 -7.4 83 9 2.8 100.41
15:00

Freezing Rain,Ice 12/17/2012


-2.6 -3.7 92 28 8.0 100.95
Pellets,Fog 3:00

Freezing Rain,Snow 1/13/2012


-5.0 -7.3 84 32 4.8 98.56
Grains 9:00

3/13/2012
Haze 14.1 11.1 86 17 9.7 102.97
23:00

9/9/2012
Mainly Clear 33.0 21.2 99 63 48.3 103.59
9:00

[Link] Data Analysis (1).html 26/29


4/6/24, 11:25 AM Weather Data Analysis

Dew
Rel Wind
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h
Temp_C

Weather condition

12/10/2012
Moderate Rain,Fog 1.7 0.8 94 17 6.4 99.98
8:00

12/27/2012
Moderate Snow -4.9 -6.7 93 39 0.8 100.67
9:00

Moderate Snow,Blowing 12/27/2012


-5.4 -6.4 93 41 0.6 100.64
Snow 12:00

9/9/2012
Mostly Cloudy 32.4 24.4 100 83 48.3 103.65
2:00

9/5/2012
Rain 22.8 20.4 99 52 48.3 102.26
2:00

9/8/2012
Rain Showers 26.4 23.0 97 41 48.3 102.31
16:00

10/20/2012
Rain Showers,Fog 12.8 12.1 96 13 6.4 99.83
3:00

Rain Showers,Snow 12/5/2012


2.2 -1.2 78 28 24.1 101.11
Showers 10:00

9/30/2012
Rain,Fog 21.7 19.5 100 46 9.7 101.77
23:00

3/13/2012
Rain,Haze 5.5 2.9 86 17 9.7 100.61
9:00

12/18/2012
Rain,Ice Pellets 0.6 -0.6 92 24 9.7 100.12
5:00

4/23/2012
Rain,Snow 1.7 0.5 94 52 25.0 101.07
3:00

12/21/2012
Rain,Snow Grains 1.9 -2.1 75 26 25.0 100.60
0:00

12/8/2012
Rain,Snow,Fog 0.8 0.3 96 9 6.4 100.73
21:00

12/21/2012
Rain,Snow,Ice Pellets 1.3 0.1 94 28 6.4 100.47
5:00

4/27/2012
Snow 3.7 0.3 96 57 25.0 102.73
9:00

11/24/2012
Snow Pellets 0.7 -6.4 59 35 2.4 99.70
15:00

3/4/2012
Snow Showers 2.9 -0.7 94 37 48.3 102.50
21:00

12/29/2012
Snow Showers,Fog -10.0 -11.1 92 22 9.7 102.52
13:00

2/25/2012
Snow,Blowing Snow -1.4 -2.9 91 48 9.7 100.62
9:00

[Link] Data Analysis (1).html 27/29


4/6/24, 11:25 AM Weather Data Analysis

Dew
Rel Wind
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h
Temp_C

Weather condition

3/14/2012
Snow,Fog 1.1 0.8 99 35 9.7 102.07
19:00

2/1/2012
Snow,Haze -3.6 -6.4 81 15 6.4 100.99
21:00

3/3/2012
Snow,Ice Pellets 0.8 -1.7 92 33 11.3 100.96
4:00

7/4/2012
Thunderstorms 26.7 20.1 87 15 25.0 100.62
16:00

Thunderstorms,Heavy 5/29/2012
10.9 9.0 88 9 2.4 100.26
Rain Showers 6:00

Thunderstorms,Moderate 7/17/2012
19.6 18.5 93 15 3.2 100.01
Rain Showers,Fog 6:00

7/23/2012
Thunderstorms,Rain 21.3 19.1 93 30 24.1 100.83
18:00

Thunderstorms,Rain 9/8/2012
25.5 23.1 98 32 25.0 101.06
Showers 4:00

Thunderstorms,Rain 7/31/2012
22.9 21.3 91 35 9.7 100.64
Showers,Fog 20:00

7/17/2012
Thunderstorms,Rain,Fog 20.6 18.6 88 19 4.8 100.08
5:00

In [96]: #[Link] all the records where weather condition is 'fog'

In [97]: [Link]()

Out[97]: Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

1/1/2012 Freezing
2 -1.8 -3.4 89 7 4.0 101.26
2:00 Drizzle,Fog

1/1/2012 Freezing
3 -1.5 -3.2 88 6 4.0 101.27
3:00 Drizzle,Fog

1/1/2012
4 -1.5 -3.3 88 7 4.8 101.23 Fog
4:00

In [98]: data[data['Weather condition'] == 'Fog']

[Link] Data Analysis (1).html 28/29


4/6/24, 11:25 AM Weather Data Analysis

Out[98]: Dew
Rel Wind Weather
Date/Time Temp_C Point Visibility_km Press_kPa
Hum_% Speed_km/h condition
Temp_C

1/1/2012
0 -1.8 -3.9 86 4 8.0 101.24 Fog
0:00

1/1/2012
1 -1.8 -3.7 87 4 8.0 101.24 Fog
1:00

1/1/2012
4 -1.5 -3.3 88 7 4.8 101.23 Fog
4:00

1/1/2012
5 -1.4 -3.3 87 9 6.4 101.27 Fog
5:00

1/1/2012
6 -1.5 -3.1 89 7 6.4 101.29 Fog
6:00

... ... ... ... ... ... ... ... ...

12/29/2012
8716 -16.0 -17.2 90 6 9.7 101.25 Fog
4:00

12/29/2012
8717 -14.8 -15.9 91 4 6.4 101.25 Fog
5:00

12/29/2012
8718 -13.8 -15.3 88 4 9.7 101.25 Fog
6:00

12/29/2012
8719 -14.8 -16.4 88 7 8.0 101.22 Fog
7:00

12/29/2012
8722 -12.0 -13.3 90 7 6.4 101.15 Fog
10:00

150 rows × 8 columns

In [ ]: #find all the

[Link] Data Analysis (1).html 29/29

Common questions

Powered by AI

Snow-related conditions, including 'Snow', 'Snow Showers', and 'Snow Pellets', occur with varied frequency. They are less common compared to clear or cloudy conditions. Instances often show lower temperatures (e.g., -5°C or below) and higher relative humidity. This pattern correlates with typical winter weather dynamics, reflecting cold air masses and precipitation .

The data presents unique wind speeds ranging between 0 and 83 km/h, indicating varied wind conditions during the year. Frequent low wind speeds, such as 4 km/h, suggest calm conditions are common. Understanding the distribution of these values can uncover predominant weather patterns, such as stable pressure systems or frequent periods of calm weather .

Relative humidity varies broadly from 20% to 100%, reflecting diverse weather conditions. High humidity is typical in foggy and rain conditions, reaching up to 100%, while low humidity (20%) aligns with clear weather. This range indicates the dataset captures varied atmospheric moisture levels, pertinent to predicting weather patterns like thunderstorms or fog .

Wind speed and visibility collectively determine the severity of weather conditions. High wind speeds and low visibility dictate hazardous conditions such as blizzards, whereas calm winds might imply fog or stable snow conditions without severe impacts. The combination of these factors can also elucidate dynamic weather scenarios such as thunderstorms where quick shifts occur .

Fog significantly reduces visibility, often to as low as 0.2 km, impacting transportation and outdoor activities. Temperature during foggy conditions is relatively stable, recorded around -1.8°C with minimal fluctuations. This relationship suggests that foggy conditions occur under stable atmospheric conditions with high relative humidity, causing water vapor to condense at lower temperatures .

The unique weather conditions recorded include 'Fog', 'Freezing Drizzle,Fog', 'Mostly Cloudy', 'Cloudy', 'Rain', 'Mainly Clear', 'Snow', 'Clear', among others. The most frequent weather condition is 'Mainly Clear' with 2106 instances, followed by 'Mostly Cloudy' with 2069 instances, and 'Cloudy' with 1728 instances. Less common are conditions like 'Rain Showers,Snow Showers', 'Snow Pellets', and 'Moderate Rain,Fog' which occur once each .

Atmospheric pressure variations influence weather conditions, with low pressure generally indicating unstable, rainy, or stormy weather, and high pressure correlating with stable, clear skies. The dataset shows pressure ranging from about 97 to 103 kPa, affecting weather conditions like 'Rain,Snow' or 'Thunderstorms,Heavy Rain Showers'. These conditions could indicate low-pressure fronts passing through, while stable conditions suggest high pressure dominance .

Generally, as temperature decreases, relative humidity tends to increase, assuming constant moisture content in the air. The dataset suggests that periods of fog, where temperatures are typically lower (around -1.8°C), coincide with higher relative humidity (around 86-89%). Conversely, higher temperatures often associate with lower relative humidity unless additional moisture sources are present .

The standard deviation of pressure provides insight into the variability of atmospheric pressure throughout the recorded period. A higher standard deviation would indicate significant fluctuations, whereas a lower value signifies stable atmospheric pressure. In this dataset, pressure standard deviation could highlight the influences of weather patterns or fronts moving through the area, reflecting significant atmospheric dynamics .

Mean visibility varies significantly with weather conditions. For instance, 'Snow Pellets' have an average visibility of 2.4 km, while 'Thunderstorms' have a higher average visibility at around 24.55 km. Meanwhile, 'Rain,Snow Grains' showcases even higher visibility on average, reaching 25 km .

You might also like