{"action":"created","issue":{"url":"https://api.github.com/repos/nilmtk/nilmtk/issues/445","labels_url":"https://api.github.com/repos/nilmtk/nilmtk/issues/445/labels{/name}","comments_url":"https://api.github.com/repos/nilmtk/nilmtk/issues/445/comments","events_url":"https://api.github.com/repos/nilmtk/nilmtk/issues/445/events","html_url":"https://github.com/nilmtk/nilmtk/issues/445","id":110976967,"number":445,"title":"How to synchronize two different data frames?","user":{"login":"haderazzini","id":13726816,"avatar_url":"https://avatars.githubusercontent.com/u/13726816?v=3","gravatar_id":"","url":"https://api.github.com/users/haderazzini","html_url":"https://github.com/haderazzini","followers_url":"https://api.github.com/users/haderazzini/followers","following_url":"https://api.github.com/users/haderazzini/following{/other_user}","gists_url":"https://api.github.com/users/haderazzini/gists{/gist_id}","starred_url":"https://api.github.com/users/haderazzini/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/haderazzini/subscriptions","organizations_url":"https://api.github.com/users/haderazzini/orgs","repos_url":"https://api.github.com/users/haderazzini/repos","events_url":"https://api.github.com/users/haderazzini/events{/privacy}","received_events_url":"https://api.github.com/users/haderazzini/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-10-12T13:38:10Z","updated_at":"2015-10-12T14:26:09Z","closed_at":null,"body":"I have two different data frames. The first is the power active of Washer Dryer and the second is an estimation of power active of Washer Dryer. I would like to subtract the two data frames to get the error between measurement and estimation. How to synchronize them?\r\n![image](https://cloud.githubusercontent.com/assets/13726816/10429185/17b6b69a-70f7-11e5-8dd6-cb39f8845d5d.png)\r\n![image](https://cloud.githubusercontent.com/assets/13726816/10429190/21ee924a-70f7-11e5-8e23-62597f8dbc1c.png)\r\n![image](https://cloud.githubusercontent.com/assets/13726816/10429195/29495020-70f7-11e5-92bb-b9b3d8842385.png)\r\n"},"comment":{"url":"https://api.github.com/repos/nilmtk/nilmtk/issues/comments/147412827","html_url":"https://github.com/nilmtk/nilmtk/issues/445#issuecomment-147412827","issue_url":"https://api.github.com/repos/nilmtk/nilmtk/issues/445","id":147412827,"user":{"login":"JackKelly","id":460756,"avatar_url":"https://avatars.githubusercontent.com/u/460756?v=3","gravatar_id":"","url":"https://api.github.com/users/JackKelly","html_url":"https://github.com/JackKelly","followers_url":"https://api.github.com/users/JackKelly/followers","following_url":"https://api.github.com/users/JackKelly/following{/other_user}","gists_url":"https://api.github.com/users/JackKelly/gists{/gist_id}","starred_url":"https://api.github.com/users/JackKelly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JackKelly/subscriptions","organizations_url":"https://api.github.com/users/JackKelly/orgs","repos_url":"https://api.github.com/users/JackKelly/repos","events_url":"https://api.github.com/users/JackKelly/events{/privacy}","received_events_url":"https://api.github.com/users/JackKelly/received_events","type":"User","site_admin":false},"created_at":"2015-10-12T14:26:09Z","updated_at":"2015-10-12T14:26:09Z","body":"Well, first you'll need to figure out which of those two dataframes have NaNs.  It's possible that there isn't any data for the washer dryer for the times when you're getting NaNs. You could do `fillna(0)` to fill the NaNs with zeros (if that is what you want to do!)\r\n\r\nIf you haven't done so already, I'd suggest reading the Pandas docs.  This is a Pandas question more than a NILMTK question, really."}}