Home Projects Weather Analysis
🌤️ Weather Analysis Python Data Visualization 2023-2024 Dataset

Philippine Major Cities Weather Analysis

14 Months of Climate Data (Nov 2023 - Dec 2024)

Comprehensive analysis of 447,000+ weather observations from 138 Philippine cities, examining temperature patterns, rainfall distribution, regional climate variations, and extreme weather events using OpenWeatherMap data.

447K+
Weather Records
138
Cities Monitored
14
Months of Data
18
Analysis Topics
Data Period
November 2023 - December 2024 (14 months)
Tech Stack
Python Pandas Chart.js HTML/CSS
Key Takeaways

Analysis of 447,000+ weather observations from 138 Philippine cities over 14 months reveals distinct climate patterns, regional temperature variations, and rainfall distribution across the archipelago.

  • The highest temperature recorded was 38.5 degrees C during summer months, while temperatures averaged between 26-30 degrees C across most cities year-round.
  • 138 cities were continuously monitored for 14 months (November 2023 to December 2024), providing comprehensive nationwide coverage.
  • Rainfall distribution varies dramatically by region, with Eastern Visayas and Pacific-facing areas receiving significantly more precipitation.
  • Distinct seasonal patterns emerge with the hottest period from March to May and the wettest from June to November, following the Philippine climate classification.

Key Weather Statistics

Summary of weather patterns across 138 Philippine cities over 14 months of continuous monitoring.

Hottest Recorded
Maximum temperature observed in dataset
38.5°C
Coolest Recorded
Minimum temperature (Baguio City)
14.2°C
Rainy Observations
Records with rainfall detected
10.5%
Dominant Weather
Most common condition
Clouds (83%)

Weather Condition Distribution

Breakdown of weather types across all observations

Detailed Weather Descriptions

Top 10 most frequent weather descriptions

Temperature Patterns

Analysis of temperature variations across cities and seasons.

Average Temperature by City (Top 20 Hottest vs Coolest)

Comparing the warmest and coolest Philippine cities

Hottest Cities

High Temp
Tuguegarao 32.8°C avg
Dagupan 32.1°C avg
Cotabato 31.9°C avg
General Santos 31.7°C avg
Laoag 31.5°C avg

Coolest Cities

Low Temp
Baguio 21.4°C avg
Tagaytay City 26.2°C avg
Malaybalay 26.8°C avg
Valencia 27.1°C avg
Tabuk 27.3°C avg

Monthly Temperature Trend

Average temperature by month (2023-2024)

Temperature Distribution

Frequency of temperature ranges

Rainfall Analysis

Understanding rainfall patterns across regions and seasons.

Rain Frequency by City

Top 15 cities with most rainy observations

Monthly Rainfall Pattern

Percentage of rainy observations by month

Wettest Month
August 2024 - Peak monsoon season
18.2% rainy
Driest Month
March 2024 - Dry season
4.1% rainy
Heavy Rain Events
Very heavy rain occurrences
400 events
Thunderstorms
Total thunderstorm observations
339 events

Regional Climate Comparison

Comparing weather patterns across Luzon, Visayas, and Mindanao.

Average Temperature by Region

Luzon vs Visayas vs Mindanao

Rainfall Distribution by Region

Regional precipitation patterns

Metro Manila Weather Profile

Detailed analysis of NCR cities: Manila, Quezon City, Makati, Pasig, Taguig

Wind Speed Analysis

Wind patterns and gusty conditions across Philippine cities.

Average Wind Speed by City

Top 15 windiest cities

Wind Speed Distribution

Frequency of wind speed ranges

Humidity Patterns

Analyzing moisture levels and their relationship with comfort.

Most Humid Cities

Average humidity percentage by city

Monthly Humidity Trend

How humidity changes throughout the year

Baguio: The Summer Capital

A special look at the Philippines' coolest city and its unique climate.

Baguio City

Cool Climate
Average Temperature 21.4°C
Lowest Recorded 14.2°C
Avg Humidity 78%
Elevation Effect -10°C vs lowlands

Manila (Comparison)

Tropical
Average Temperature 30.2°C
Highest Recorded 36.8°C
Avg Humidity 72%
Urban Heat Island +2-3°C

Baguio vs Manila: Monthly Temperature Comparison

The dramatic temperature difference between highland and lowland cities

Extreme Weather Events

Tracking severe weather occurrences across the archipelago.

Heavy Rain Events by Month

Very heavy rain and thunderstorm occurrences

Extreme Weather Types

Distribution of severe weather conditions

Cities Most Affected by Extreme Weather

Frequency of severe conditions by location

Philippine Climate Seasons

Understanding the dry (Amihan) and wet (Habagat) seasons.

Amihan (Dry Season)

Nov - Apr
Average Temperature 29.8°C
Rain Frequency 6.2%
Clear Sky Days 8.5%
Avg Humidity 68%

Habagat (Wet Season)

May - Oct
Average Temperature 29.2°C
Rain Frequency 14.8%
Clear Sky Days 4.2%
Avg Humidity 76%

Seasonal Weather Comparison

Key metrics comparison between dry and wet seasons

Cloud Cover Analysis

Understanding sky conditions and cloud patterns.

Cloud Cover Distribution

Breakdown of sky conditions

Clear Sky Frequency by City

Cities with most sunny days

Heat Index & Comfort Level

Analyzing "feels like" temperature based on humidity.

Feels Like vs Actual Temperature

Heat index comparison by city

Monthly Heat Index Trend

How perceived temperature changes over time

Highest Heat Index
Maximum "feels like" temperature
45°C
Avg Heat Index Diff
Average difference from actual temp
+3.2°C
Danger Zone Events
Heat index above 41°C
2,847

Atmospheric Pressure Analysis

Tracking pressure patterns and their weather implications.

Average Pressure by City

Sea level pressure variations

Pressure vs Weather Conditions

Correlation between pressure and weather

Visibility Conditions

Analysis of visibility ranges and low-visibility events.

Visibility Distribution

Frequency of visibility ranges

Low Visibility Events

Fog, mist, and haze occurrences by month

Day vs Night Temperature

Understanding temperature variations throughout the day.

Hourly Temperature Pattern

Average temperature by time of day (3-hour intervals)

Daytime (6AM - 6PM)

Warm
Average Temperature 30.8°C
Peak Hour 1-3 PM
Avg Humidity 65%

Nighttime (6PM - 6AM)

Cool
Average Temperature 27.4°C
Coolest Hour 4-6 AM
Avg Humidity 78%

Best Weather Destinations

Cities ranked by climate comfort for travelers.

Climate Comfort Score by City

Based on temperature, humidity, and rain frequency (higher = more comfortable)

Best Months to Visit

Climate comfort score by month

Month Avg Temp Rain % Humidity Recommendation
January 28.2°C 5.8% 71% Excellent
February 28.5°C 4.5% 68% Excellent
March 29.8°C 4.1% 65% Excellent
April 31.2°C 5.2% 64% Hot but Dry
May 31.5°C 10.8% 70% Transition
June 30.2°C 15.2% 76% Rainy Season
July 29.5°C 17.5% 78% Rainy Season
August 29.2°C 18.2% 79% Peak Monsoon
September 29.0°C 16.8% 78% Rainy Season
October 29.1°C 14.2% 76% Transition
November 28.8°C 9.5% 74% Good
December 28.0°C 7.2% 73% Excellent

Key Findings

Major insights from the weather data analysis.

Baguio's Unique Climate

Baguio City averages 21.4°C, nearly 10°C cooler than lowland cities, making it the Philippines' natural air conditioning due to its 1,500m elevation.

Cloud Dominance

83% of all observations recorded cloudy conditions, with only 6% clear skies - the Philippines is predominantly overcast year-round.

Tuguegarao Heat Champion

Tuguegarao consistently records the highest temperatures averaging 32.8°C, earning its reputation as the country's hottest city.

Monsoon Impact

Wet season (Habagat) brings 2.4x more rain than dry season, with August being the wettest month at 18.2% rainy observations.

Heat Index Warning

2,847 observations recorded "danger zone" heat index above 41°C, primarily in April-May when humidity compounds high temperatures.

Regional Differences

Mindanao cities experience more stable temperatures year-round, while Luzon shows greater seasonal variation due to monsoon exposure.

Best Travel Window

January to March offers optimal weather with lowest rainfall (4-6%), moderate humidity (65-71%), and comfortable temperatures (28-30°C).

Daily Temperature Swing

Average day-night temperature difference is 3.4°C, with peak temperatures at 1-3 PM and coolest readings at 4-6 AM.

Urban Heat Islands

Metro Manila cities average 2-3°C warmer than surrounding provinces, demonstrating the urban heat island effect.

Extreme Weather Rare

Thunderstorms (339 events) and very heavy rain (400 events) represent less than 0.2% of all observations, indicating generally stable weather.

Data Source & Methodology

Understanding the data collection and analysis approach.

Data Source

Provider OpenWeatherMap
Collection Period Nov 2023 - Dec 2024
Interval 3-hour intervals
Dataset Kaggle Public

Coverage

Total Records 447,179
Cities 138 major cities
Regions All 17 regions
Variables 27 weather metrics
Variables Analyzed
Temperature, feels-like, humidity, pressure, wind speed/direction, visibility, cloud cover, rainfall, weather conditions
Limitations
Data represents point observations at 3-hour intervals; actual conditions may vary between readings
Analysis Tools
Chart.js for visualization, JavaScript for data processing, CSS for responsive design

Have Data But Need Help?

If you have raw data and want to transform it into meaningful insights like this analysis, I'd love to help! Whether it's business data, research datasets, or any information you want to visualize and understand better.

Have a dataset you'd like analyzed or need a mini AI project as a starter guide? Send me your suggestions!

Connect on LinkedIn Email Me Dev.to Articles 💬 Messenger