CoCalc -- Concat_and_MissingData.ipynb

GEP475GROUPINEEDANAP

³⁸⁹² views

Kernel: Python 3

In [25]:

import pandas as pd

In [26]:

df1 = pd.read_csv('NetAtmo_2016.csv', parse_dates = True,)

In [27]:

df2 = pd.read_csv('NetAtmo_2017.csv', parse_dates = True)

In [28]:

df1.head(1)

Out[28]:

In [29]:

df2.head(1)

Out[29]:

In [30]:

df1['Time'] = df1['Timezone : America/Los_Angeles']
df1.head(1)

Out[30]:

In [31]:

df1.drop(df1.columns[[0,1,2,3,5,6]], axis =1, inplace = True)
df1.head(1)

Out[31]:

In [32]:

df2.drop(df2.columns[[0,2,3,5,6]], axis =1, inplace = True)
df2.head(1)

Out[32]:

In [33]:

#df1['Time'] = pd.to_datetime(df1.Time)

In [34]:

#df2['Time'] = pd.to_datetime(df2.Time)

In [35]:

df1.head(1)

Out[35]:

In [36]:

df2.head(2)

Out[36]:

In [37]:

#df1.set_index('Time', inplace = True)

In [38]:

#df2.set_index('Time', inplace = True)

In [39]:

df1.head(1)

Out[39]:

In [40]:

df2.tail(1)

Out[40]:

In [41]:

df3 = pd.concat([df1,df2])

In [42]:

df3.head()

Out[42]:

In [43]:

df3.tail()

Out[43]:

In [44]:

df3.dropna(how ='any', inplace = True)

In [45]:

df3.describe()

Out[45]:

In [46]:

df3.reset_index()

Out[46]:

In [47]:

df3.to_csv('InfiltrationCleanedData.csv')

In [ ]: