DataCleaning1.ipynb

Kernel: Python 3 (Anaconda)

import numpy as np
import pandas as pd
%matplotlib inline
import matplotlib.pyplot as plt

year1 = pd.read_csv('../DataFiles/Raw/NetAtmo_2016.csv' , parse_dates=True, index_col=1)
year2 = pd.read_csv('../DataFiles/Raw/NetAtmo_2017.csv' , parse_dates=True, index_col=1)

Jupyter Kernel terminated: This might be caused by running out of memory or hitting a bug in some library (e.g., forking too many processes, trying to access invalid memory, etc.). Consider restarting or upgrading your project or running the relevant code directly in a terminal to track down the cause, as explained here.

year1.index.names = ['Time']
year2.index.names = ['Time']
print(year1.head(5))
year2.head(2)

                      Timestamp  Temperature  Humidity    CO2  Noise  Pressure
Time                                                                          
2016-02-19 13:26:00  1455917199         18.8        76    NaN    NaN    1015.7
2016-02-19 13:27:00  1455917255         19.2        75  718.0    NaN    1015.7
2016-02-19 13:27:00  1455917257         19.9        73    NaN    NaN    1015.7
2016-02-19 13:31:00  1455917513         20.3        73  337.0   44.0    1015.8
2016-02-19 13:36:00  1455917814         21.2        70  332.0   47.0    1015.7

	Timestamp	Temperature	Humidity	CO2	Noise	Pressure
Time
2017-01-01 00:00:00	1483257658	21.8	34	482	39	1009.1
2017-01-01 00:05:00	1483257959	21.8	34	491	41	1009.2

first_year = year1['CO2']
second_year = year2['CO2']
first_year.index[1].names = ['ppm'] #Y the fuck this no work
second_year.index[1].names = ['ppm']
tot = first_year + second_year
tot

Jupyter Kernel terminated: This might be caused by running out of memory or hitting a bug in some library (e.g., forking too many processes, trying to access invalid memory, etc.). Consider restarting or upgrading your project or running the relevant code directly in a terminal to track down the cause, as explained here.

first_year = year1['CO2']
second_year = year2['CO2']
first_year.index[1].names = ['ppm'] #Y the fuck this no work
second_year.index[1].names = ['ppm']
tot = first_year + second_year
print(len(tot))
print(len(first_year) + len(second_year))
%matplotlib inline
tot.plot()

Jupyter Kernel terminated: This might be caused by running out of memory or hitting a bug in some library (e.g., forking too many processes, trying to access invalid memory, etc.). Consider restarting or upgrading your project or running the relevant code directly in a terminal to track down the cause, as explained here.