Baselight
Sign In

Over A Century Of Indian Climate Data (1901–2017)

Monthly, Seasonal, and Annual Observations of Temperature & Rainfall from the In

@kaggle.richard47_weather_india_from_1901_to_2017

Mean Temp India
@kaggle.richard47_weather_india_from_1901_to_2017.mean_temp_india

  • 21.5 KB
  • 117 rows
  • 18 columns
year

YEAR

jan

JAN

feb

FEB

mar

MAR

apr

APR

may

MAY

jun

JUN

jul

JUL

aug

AUG

sep

SEP

oct

OCT

nov

NOV

dec

DEC

annual

ANNUAL

jan_feb

JAN-FEB

mar_may

MAR-MAY

jun_sep

JUN-SEP

oct_dec

OCT-DEC

190117.9919.4323.4926.4128.2828.627.4926.9826.2625.0821.7318.9524.2318.7126.0627.321.92
19021920.3924.126.5428.6828.4427.2927.0525.9524.3721.3318.7824.3319.726.4427.1821.49
190318.3219.7922.4626.0327.9328.4128.0426.6326.3424.5720.9618.2923.819.0525.4727.1721.27
190417.7719.3922.9526.7327.8327.8526.8426.7325.8424.3621.0718.8423.8618.6625.8426.8321.42
190517.417.7921.7824.8428.3228.6927.6727.4726.2926.1622.0718.7123.7117.5824.9927.3721.48
190617.519.1422.2126.5329.0628.0227.4626.8226.2324.7521.9319.5524.1218.3725.9327.1522.08
190719.2719.4222.0326.9827.5227.6627.2826.3826.2624.7222.1118.4623.8719.3524.8926.8921.76
190818.3519.7322.9327.0628.0728.4927.1626.4125.7424.2521.0618.1523.9519.0426.0226.9521.17
190917.7919.0523.425.7627.9727.6726.5626.4325.4724.3722.0118.8623.7818.4225.7126.5321.75
191018.1419.7222.925.9628.3627.7226.9326.6125.9824.0420.7218.0523.7718.9325.7426.8120.96

CREATE TABLE mean_temp_india (
  "year" BIGINT,
  "jan" DOUBLE,
  "feb" DOUBLE,
  "mar" DOUBLE,
  "apr" DOUBLE,
  "may" DOUBLE,
  "jun" DOUBLE,
  "jul" DOUBLE,
  "aug" DOUBLE,
  "sep" DOUBLE,
  "oct" DOUBLE,
  "nov" DOUBLE,
  "dec" DOUBLE,
  "annual" DOUBLE,
  "jan_feb" DOUBLE,
  "mar_may" DOUBLE,
  "jun_sep" DOUBLE,
  "oct_dec" DOUBLE
);