plotting time series data
play

Plotting time - series data IN TR OD U C TION TO DATA VISU AL - PowerPoint PPT Presentation

Oct 14, 2022 •346 likes •627 views

Plotting time - series data IN TR OD U C TION TO DATA VISU AL IZATION W ITH MATP L OTL IB Ariel Rokem Data Scientist Time - series data INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB Climate change time - series date,co2,relative_temp

  1. Plotting time - series data IN TR OD U C TION TO DATA VISU AL IZATION W ITH MATP L OTL IB Ariel Rokem Data Scientist

  2. Time - series data INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  3. Climate change time - series date,co2,relative_temp 1958-03-06,315.71,0.1 1958-04-06,317.45,0.01 1958-05-06,317.5,0.08 1958-06-06,-99.99,-0.05 1958-07-06,315.86,0.06 1958-08-06,314.93,-0.06 ... 2016-08-06,402.27,0.98 2016-09-06,401.05,0.87 2016-10-06,401.59,0.89 2016-11-06,403.55,0.93 2016-12-06,404.45,0.81 INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  4. DateTimeInde x climate_change.index DatetimeIndex(['1958-03-06', '1958-04-06', '1958-05-06', '1958-06-06', '1958-07-06', '1958-08-06', '1958-09-06', '1958-10-06', '1958-11-06', '1958-12-06', ... '2016-03-06', '2016-04-06', '2016-05-06', '2016-06-06', '2016-07-06', '2016-08-06', '2016-09-06', '2016-10-06', '2016-11-06', '2016-12-06'], dtype='datetime64[ns]', name='date', length=706, freq=None) INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  5. Time - series data climate_change['relative_temp'] climate_change['co2'] 0 0.10 0 315.71 1 0.01 1 317.45 2 0.08 2 317.50 3 -0.05 3 NaN 4 0.06 4 315.86 5 -0.06 5 314.93 6 -0.03 6 313.20 7 0.04 7 NaN ... ... 701 0.98 701 402.27 702 0.87 702 401.05 703 0.89 703 401.59 704 0.93 704 403.55 705 0.81 705 404.45 Name:co2, Length: 706, dtype: float64 Name:co2, Length: 706, dtype: float64 INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  6. Plotting time - series data import matplotlib.pyplot as plt fig, ax = plt.subplots() ax.plot(climate_change.index, climate_change['co2']) ax.set_xlabel('Time') ax.set_ylabel('CO2 (ppm)') plt.show() INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  7. Zooming in on a decade sixties = climate_change["1960-01-01":"1969-12-31"] fig, ax = plt.subplots() ax.plot(sixties.index, sixties['co2']) ax.set_xlabel('Time') ax.set_ylabel('CO2 (ppm)') plt.show() INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  8. Zooming in on one y ear sixty_nine = climate_change["1969-01-01":"1969-12-31"] fig, ax = plt.subplots() ax.plot(sixty_nine.index, sixty_nine['co2']) ax.set_xlabel('Time') ax.set_ylabel('CO2 (ppm)') plt.show() INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  9. Let ' s practice time - series plotting ! IN TR OD U C TION TO DATA VISU AL IZATION W ITH MATP L OTL IB

  10. Plotting time - series w ith different v ariables IN TR OD U C TION TO DATA VISU AL IZATION W ITH MATP L OTL IB Ariel Rokem Data Scientist

  11. Plotting t w o time - series together import pandas as pd climate_change = pd.read_csv('climate_change.csv', parse_dates=["date"], index_col="date") climate_change co2 relative_temp date 1958-03-06 315.71 0.10 1958-04-06 317.45 0.01 1958-07-06 315.86 0.06 ... ... ... 2016-11-06 403.55 0.93 2016-12-06 404.45 0.81 [706 rows x 2 columns] INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  12. Plotting t w o time - series together import matplotlib.pyplot as plt fig, ax = plt.subplots() ax.plot(climate_change.index, climate_change["co2"]) ax.plot(climate_change.index, climate_change["relative_temp"]) ax.set_xlabel('Time') ax.set_ylabel('CO2 (ppm) / Relative temperature') plt.show() INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  13. Using t w in a x es fig, ax = plt.subplots() ax.plot(climate_change.index, climate_change["co2"]) ax.set_xlabel('Time') ax.set_ylabel('CO2 (ppm)') ax2 = ax.twinx() ax2.plot(climate_change.index, climate_change["relative_temp"]) ax2.set_ylabel('Relative temperature (Celsius)') plt.show() INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  14. Separating v ariables b y color fig, ax = plt.subplots() ax.plot(climate_change.index, climate_change["co2"], color='blue') ax.set_xlabel('Time') ax.set_ylabel('CO2 (ppm)', color='blue') ax2 = ax.twinx() ax2.plot(climate_change.index, climate_change["relative_temp"], color='red') ax2.set_ylabel('Relative temperature (Celsius)', color='red') plt.show() INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  15. Coloring the ticks fig, ax = plt.subplots() ax.plot(climate_change.index, climate_change["co2"], color='blue') ax.set_xlabel('Time') ax.set_ylabel('CO2 (ppm)', color='blue') ax.tick_params('y', colors='blue') ax2 = ax.twinx() ax2.plot(climate_change.index, climate_change["relative_temp"], color='red') ax2.set_ylabel('Relative temperature (Celsius)', color='red') ax2.tick_params('y', colors='red') plt.show() INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  16. Coloring the ticks INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  17. A f u nction that plots time - series def plot_timeseries(axes, x, y, color, xlabel, ylabel): axes.plot(x, y, color=color) axes.set_xlabel(xlabel) axes.set_ylabel(ylabel, color=color) axes.tick_params('y', colors=color) INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  18. Using o u r f u nction fig, ax = plt.subplots() plot_timeseries(ax, climate_change.index, climate_change['co2'], 'blue', 'Time', 'CO2 (ppm)') ax2 = ax.twinx() plot_timeseries(ax, climate_change.index, climate_change['relative_temp'], 'red', 'Time', 'Relative temperature (Celsius)') plt.show() INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  19. Create y o u r o w n f u nction ! IN TR OD U C TION TO DATA VISU AL IZATION W ITH MATP L OTL IB

  20. Annotating time - series data IN TR OD U C TION TO DATA VISU AL IZATION W ITH MATP L OTL IB Ariel Rokem Data Scientist

  21. Time - series data INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  22. Annotation fig, ax = plt.subplots() plot_timeseries(ax, climate_change.index, climate_change['co2'], 'blue', 'Time', 'CO2 (ppm)') ax2 = ax.twinx() plot_timeseries(ax2, climate_change.index, climate_change['relative_temp'], 'red', 'Time', 'Relative temperature (Celsius)') ax2.annotate(">1 degree", xy=[pd.TimeStamp("2015-10-06"), 1]) plt.show() INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  23. Positioning the te x t ax2.annotate(">1 degree", xy=(pd.Timestamp('2015-10-06'), 1), xytext=(pd.Timestamp('2008-10-06'), -0.2)) INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  24. Adding arro w s to annotation ax2.annotate(">1 degree", xy=(pd.Timestamp('2015-10-06'), 1), xytext=(pd.Timestamp('2008-10-06'), -0.2), arrowprops={}) INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  25. C u stomi z ing arro w properties ax2.annotate(">1 degree", xy=(pd.Timestamp('2015-10-06'), 1), xytext=(pd.Timestamp('2008-10-06'), -0.2), arrowprops={"arrowstyle":"->", "color":"gray"}) INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  26. C u stomi z ing annotations h � ps :// matplotlib . org /u sers / annotations . html INTRODUCTION TO DATA VISUALIZATION WITH MATPLOTLIB

  27. Practice annotating plots ! IN TR OD U C TION TO DATA VISU AL IZATION W ITH MATP L OTL IB

Recommend

Time Series Representations for Better Data Mining What can we do with time series data?

Time Series Representations for Better Data Mining What can we do with time series data?

Time Series Representations for Better Data Mining What can we do with time series data? Clustering Anomaly (outlier) detection Forecasting What are the problems with time series data? Noise Concept-drift (trend-shift

122 views • 11 slides
Why do you care? Time-series data is all over the place. Time-Series Data Kaitlin Duck

Why do you care? Time-series data is all over the place. Time-Series Data Kaitlin Duck

Why do you care? Time-series data is all over the place. Time-Series Data Kaitlin Duck Sherwood CS 533c What is Time-Series Data? What is Time-Series Data? Lines. Usually periodic Source: van Wijk and van Selow, Cluster and

85 views • 4 slides
Introduction to Time Series Heino Bohn Nielsen 1 of 15 Outline (1) What is a time series? (2)

Introduction to Time Series Heino Bohn Nielsen 1 of 15 Outline (1) What is a time series? (2)

Econometrics 2 Fall 2005 Introduction to Time Series Heino Bohn Nielsen 1 of 15 Outline (1) What is a time series? (2) Important characteristics of time series data. (3) Data sampling and stochastic processes. Cross-sectional data vs. time

374 views • 8 slides
Time Series Data Visualization Class 2, Part A 2 1 Time Series Data Fundamental

Time Series Data Visualization Class 2, Part A 2 1 Time Series Data Fundamental

Large Scale Information Visualization Jing Yang Fall 2007 1 Time Series Data Visualization Class 2, Part A 2 1 Time Series Data Fundamental chronological component to the data set Random sample of 4000 graphics from 15 of

763 views • 31 slides
Time Series Data Visualization 2 1 Time Series Data Fundamental chronological component to

Time Series Data Visualization 2 1 Time Series Data Fundamental chronological component to

Information Visualization Jing Yang Spring 2007 1 Time Series Data Visualization 2 1 Time Series Data Fundamental chronological component to the data set Random sample of 4000 graphics from 15 of worlds newspapers and magazines

315 views • 31 slides
Lecture4: Plotting Lecture4: Plotting 1 Plotting in MATLAB 2D Plots Plotting Scalar functions

Lecture4: Plotting Lecture4: Plotting 1 Plotting in MATLAB 2D Plots Plotting Scalar functions

Lecture4: Plotting Lecture4: Plotting 1 Plotting in MATLAB 2D Plots Plotting Scalar functions Plot f ( x ) = x 2 on [ 2 , 2 ]. Define a discrete set of values uniformly distributed on the domain of f . 1 Evaluate f at each point in

603 views • 44 slides
Time Series Analysis and Mining with R Time Series Decomposi- tion Time Series Forecasting

Time Series Analysis and Mining with R Time Series Decomposi- tion Time Series Forecasting

R and Time Series Data Time Series Analysis and Mining with R Time Series Decomposi- tion Time Series Forecasting Yanchang Zhao Time Series Clustering Time Series RDataMining.com Classification http://www.rdatamining.com/ R Functions

1.91k views • 42 slides
Timeseries kinds and applications MAC H IN E L E AR N IN G FOR TIME SE R IE S DATA IN P YTH

Timeseries kinds and applications MAC H IN E L E AR N IN G FOR TIME SE R IE S DATA IN P YTH

Timeseries kinds and applications MAC H IN E L E AR N IN G FOR TIME SE R IE S DATA IN P YTH ON Chris Holdgraf Fello w, Berkele y Instit u te for Data Science Time Series MACHINE LEARNING FOR TIME SERIES DATA IN PYTHON Time Series

802 views • 37 slides
What the heck is time-series data (and why do I need a time-series database?) Ajay Kulkarni |

What the heck is time-series data (and why do I need a time-series database?) Ajay Kulkarni |

What the heck is time-series data (and why do I need a time-series database?) Ajay Kulkarni | Co-founder/CEO | ajay@timescale.com Fastest growing database category Source: DB Engines In this talk 1. What is time-series data? (hint: its

540 views • 36 slides
W HAT IS TIME SERIES D ATA ? W HAT IS TIME SERIES D ATA ? A value over time W HAT IS TIME

W HAT IS TIME SERIES D ATA ? W HAT IS TIME SERIES D ATA ? A value over time W HAT IS TIME

T IME S ERIES D ATA P APERS C OVERED Interactive Visualization of Serial Periodic Data John V. Carlis and Joseph A. Konstan Visualizing and Discovering Non-Trivial Patterns in Large Time Series Databases Jessica Lin, Eamonn Keogh,

764 views • 32 slides
CS6220: DATA MINING TECHNIQUES Mining Time Series Data Instructor: Yizhou Sun yzsun@ccs.neu.edu

CS6220: DATA MINING TECHNIQUES Mining Time Series Data Instructor: Yizhou Sun yzsun@ccs.neu.edu

CS6220: DATA MINING TECHNIQUES Mining Time Series Data Instructor: Yizhou Sun yzsun@ccs.neu.edu November 12, 2013 Mining Time Series Data Basic Concepts Time Series Prediction and Forecasting Time Series Similarity Search

649 views • 45 slides
Working w ith more than one time series VISU AL IZIN G TIME SE R IE S DATA IN P YTH ON Thomas

Working w ith more than one time series VISU AL IZIN G TIME SE R IE S DATA IN P YTH ON Thomas

Working w ith more than one time series VISU AL IZIN G TIME SE R IE S DATA IN P YTH ON Thomas Vincent Head of Data Science , Ge y Images Working w ith m u ltiple time series An isolated time series A le w ith m u ltiple time series

505 views • 29 slides
Mining Approximate Top-K Subspace Anomalies in Multi-Dimensional Time-Series Data Xiaolei Li,

Mining Approximate Top-K Subspace Anomalies in Multi-Dimensional Time-Series Data Xiaolei Li,

Mining Approximate Top-K Subspace Anomalies in Multi-Dimensional Time-Series Data Xiaolei Li, Jiawei Han University of Illinois at Urbana-Champaign VLDB 2007 1 Time Series Data Many applications produce time series data Intel stock 2

888 views • 60 slides
Introduction to Time Series Data and Analysis Simon Taylor Department of Mathematics and

Introduction to Time Series Data and Analysis Simon Taylor Department of Mathematics and

Introduction to Time Series Data and Analysis Simon Taylor Department of Mathematics and Statistics 20 April 2016 Contents What is Time Series Data? Analysis Tools Trace Plot Auto-Correlation Function Spectrum Time Series Models Moving

876 views • 18 slides
Time Series A time series is a collection of data obtained by observing a response variable at

Time Series A time series is a collection of data obtained by observing a response variable at

ST 430/514 Introduction to Regression Analysis/Statistics for Management and the Social Sciences II Time Series A time series is a collection of data obtained by observing a response variable at various times. Examples The monthly Case-Shiller

351 views • 8 slides
Query by Content for Time Series Data in RDBMS 1 I N E S F . V E G A - L O P E Z University

Query by Content for Time Series Data in RDBMS 1 I N E S F . V E G A - L O P E Z University

Query by Content for Time Series Data in RDBMS 1 I N E S F . V E G A - L O P E Z University of Houston, Computer Science Seminar 12/6/13 Roadmap 2 Querying non-text data Time series data ECG data ECG sequence

646 views • 36 slides
Merging time series MAN IP U L ATIN G TIME SE R IE S DATA W ITH XTS AN D ZOO IN R Je re y

Merging time series MAN IP U L ATIN G TIME SE R IE S DATA W ITH XTS AN D ZOO IN R Je re y

Merging time series MAN IP U L ATIN G TIME SE R IE S DATA W ITH XTS AN D ZOO IN R Je re y R y an Creator of x ts and q u antmod Introd u cing merge () Combine series b y col u mn cbind() and merge() Database st y le joins on inde x ( i . e

597 views • 18 slides
Time-Series Data Numerical data obtained at regular time intervals The time intervals can

Time-Series Data Numerical data obtained at regular time intervals The time intervals can

Time-Series Data Numerical data obtained at regular time intervals The time intervals can be annually, quarterly, daily, hourly, etc. Example: Year: 1999 2000 2001 2002 2003 Sales: 75.3 74.2 78.5 79.7 80.2

1.05k views • 55 slides
Data Mining Techniques CS 6220 - Section 3 - Fall 2016 Lecture 18: Time Series Jan-Willem van de

Data Mining Techniques CS 6220 - Section 3 - Fall 2016 Lecture 18: Time Series Jan-Willem van de

Data Mining Techniques CS 6220 - Section 3 - Fall 2016 Lecture 18: Time Series Jan-Willem van de Meent ( credit: Aggarwal Chapter 14.3 ) Time Series Data http://www.capitalhubs.com/2012/08/the-correlation-between-apple-product.html Time Series

589 views • 22 slides
How to use Dates & Times with pandas Manipulating Time Series Data in Python Date & Time

How to use Dates & Times with pandas Manipulating Time Series Data in Python Date & Time

MANIPULATING TIME SERIES DATA IN PYTHON How to use Dates & Times with pandas Manipulating Time Series Data in Python Date & Time Series Functionality At the root: data types for date & time information Objects for points in

279 views • 25 slides
Analysis Manuel Len Hoyos Overview What is Time Series Data? Index Prices: Crude Oil

Analysis Manuel Len Hoyos Overview What is Time Series Data? Index Prices: Crude Oil

Time Series Analysis Manuel Len Hoyos Overview What is Time Series Data? Index Prices: Crude Oil Gold Bitcoin What is Time Series Analysis? Uses Forecasting Time Series Data A collection of observations of a

738 views • 17 slides
Compare Time Series Growth Rates Manipulating Time Series Data in Python Comparing Stock

Compare Time Series Growth Rates Manipulating Time Series Data in Python Comparing Stock

MANIPULATING TIME SERIES DATA IN PYTHON Compare Time Series Growth Rates Manipulating Time Series Data in Python Comparing Stock Performance Stock price series: hard to compare at di ff erent levels Simple solution: normalize price

670 views • 39 slides
Time series Decomposing a series into meaningful components R.W. Oldford Time series data -

Time series Decomposing a series into meaningful components R.W. Oldford Time series data -

Time series Decomposing a series into meaningful components R.W. Oldford Time series data - Sunspot activity Recall the measurements of monthly mean relative sunspot numbers from 1749 to 1983 plotted as Monthly sunspot activity 200 Sunspot

860 views • 71 slides
Time-Series Data in MongoDB on a Budget Peter Schwaller Senior Director Server Engineering,

Time-Series Data in MongoDB on a Budget Peter Schwaller Senior Director Server Engineering,

Time-Series Data in MongoDB on a Budget Peter Schwaller Senior Director Server Engineering, Percona Santa Clara, California | April 23th 25th, 2018 TIME SERIES DATA in MongoDB on a Budget Click to add text What is Time-Series Data?

585 views • 43 slides

More recommend