Skip to content

Analyze and Visualize your data with Jupyter Notebook

1
2
3
4
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns; sns.set()
%matplotlib inline

Retrieve your data using URL

1
2
data = pd.read_json("https://citizenscience.gcoos.org/openapi/v1/natures_academy/data")
data.head()

DataHead

Read information of data set

1
data.info()

DataInfo1

Convert string to numeric

1
2
3
4
5
numeric_columns = ['No', 'Site_ID', 'Participants','AirTemp_C', 'Wind_Speed_mph',
               'Tide_stage', 'WaterTemp_C', 'Salinity_ppt', 'Turbidity_NTU', 'pH',
               'DissolvedOxygen_ppm', 'Nitrates_ppm', 'Litter_kg']
data[numeric_columns] = data[numeric_columns].apply(pd.to_numeric, errors='coerce')
data.info()

DataInfo2

Water Temperatur chart

1
sns.lineplot(data=data, x="Date_Time",y="WaterTemp_C", markers=True, dashes=False);

WaterTemp

Distribution of Water Temperature

1
sns.distplot(data["WaterTemp_C"]);

WaterDist

Pair plot

1
2
data_pair = data_num.drop(["No","Site_ID"], axis=1)
g = sns.pairplot(data_pair)

PairPlot