Posts

Showing posts from December 12, 2018

寿阳

Image
壽陽 可指以下地名: 壽陽縣,山西省的一個縣。 壽縣,安徽省的一個縣,東晉時稱 壽陽 。 这是一个消歧义页,羅列了有相同或相近的标题,但內容不同的条目。 如果您是通过某條目的内部链接而转到本页,希望您能協助修正该處的内部链接,將它指向正确的条目。 This page is only for reference, If you need detailed information, please check here

Filling the missing data in a timeseries by making an average time series

Image
up vote 1 down vote favorite I have an hourly dataseries in pandas for about 10 years. Sometimes the data is missing for 2-3 months. I want to fill the missing periods. The process I thought of it is as follows. Create one year hourly timeseries from the available data that is calculated by average values for each day and hour. Fill the missing values from this average time series. For example if 2009/01/28 1:00pm is missing, it will locate 01/28 1:00pm from the timeseries calculated in the first step and fill it. I tried searching a lot, but I could not accomplish this task. Any help will be appreciated. Edit: This is my attempt so far. I am still testing it. It takes a long time though. for count in dfaverage.index: currentday = count.day currentmonth = count.month currenthour = count.hour match_

Djibouti

Image
This article is about the country in the Horn of Africa. For its capital city, see Djibouti (city). For other uses, see Djibouti (disambiguation). Republic of Djibouti République de Djibouti    (French) جمهورية جيبوتي    (Arabic) Jamhuuriyadda Jabuuti    (Somali) Gabuutih Ummuuno    (Afar) Flag Emblem Motto:  اتحاد، مساواة، سلام   (Arabic) Unité, Égalité, Paix   (French) Inkittino, Waguitto, Amaan   (Afar) Midnimada, Sinaanta, Nabadda   (Somali) Unity, Equality, Peace Anthem:  Djibouti Location of   Djibouti    (dark blue) – in Africa    (light blue & dark grey) – in the African Union    (light blue) Capital and largest city Djibouti 11°36′N 43°10′E  /  11.600°N 43.167°E  / 11.600; 43.167 Official languages Arabic French [1] Recognised national languages Afar Somali [2] Ethnic groups Somalis 60% Afar 35% others 5%