<jupyter_start><jupyter_text>MEGI001-2101033 Introduction to Earth System Data Task 4.2 - Loading DataCreated on: Jan 22, 2019 by <NAME>   T4.2 Time series in excel format as download* Please open the downloaded file with either MS Excel or Libreoffice* plot  Excel File First, we obtain (download) the file.Using FTP access:* Link: ftp://ftp.ncdc.noaa.gov/pub/data/paleo/historical/* Path: /pub/data/paleo/historical/europe/* filename: dobrovolny2010temperature.xlsCurrent file location: [../assets/data/dobrovolny2010temperature@task4.2.xls](../assets/data/dobrovolny2010temperature@task4.2.xls)Preview - Excel Sample<jupyter_code># -*- coding: utf-8 -*-
"""
Created on Jan 23 2019

@author: <NAME>, <NAME>
"""
# this can be used for any data load and eventual plot, from composition, to spectral, time series (present example)
import pandas as pd
import numpy as np
from matplotlib import pyplot as plt

# define file path to load data from file
path = '../assets/data/'
filename = 'dobrovolny2010temperature@task4.2.xls'

# load and show data from excel source
xl = pd.ExcelFile(path + filename)
xl.sheet_names
Jan = xl.parse("Jan")
Feb = xl.parse("Feb")
Mar = xl.parse("Mar")
Apr = xl.parse("Apr")
May = xl.parse("May")
Jun = xl.parse("Jun")
Jul = xl.parse("Jul")
Aug = xl.parse("Aug")
Sep = xl.parse("Sep")
Oct = xl.parse("Oct")
Nov = xl.parse("Nov")
Dec = xl.parse("Dec")
Annual =  xl.parse("ANN")
Annual.head()
# Plotting all columns
Annual.plot('Year AD', 'SPLICED')<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.14019933554817277, 'fraction_numerical': 0.03255813953488372, 'mean_word_length': 4.8828125, 'pattern_counts': {'":': 0, '<': 8, '<?xml version=': 0, '>': 8, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 3, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 3, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '613180', 'license': 'MIT', 'n_tokens_mistral': 576, 'n_tokens_neox': 518, 'n_words': 156, 'path': 'notebooks/task_4/florent-ralph_task4.2.ipynb', 'repo_name': 'ralflorent/owm', 'size': '1525'}