Stack Overflow
Stack Overflow

Questions tagged [timeserieschart]

A time series chart, also called a times series graph, is an illustration of data points at successive time intervals.

396 questions
5
votes
1 answer

python pandas: transform start and end datetime range (stored as 2 columns) to individual rows (eqpt utilisation)

Hi I have a data set like below df.. I am providing the image and sample dataframe separately. I want to transform the original dataframe (df) to transformed dataframe (dft) so that I can see the utilisation of each equipment for a 24 hour period…
ihightower
  • 3,093
  • 6
  • 34
  • 49
5
votes
3 answers

How to plot dates on the x-axis using Seaborn (or matplotlib)

I have a csv file with some time series data. I create a Data Frame as such: df = pd.read_csv('C:\\Desktop\\Scripts\\TimeSeries.log') When I call df.head(6), the data appears as follows: Company Date Value ABC 08/21/16…
equanimity
  • 2,371
  • 3
  • 29
  • 53
5
votes
1 answer

determine the coordinates where two pandas time series cross, and how many times the time series cross

If I were to graph two time series, let's say they both have an upward positive trend from left to right, is there anyway to use pandas to find where the two lines intersect and how often? For example: How often do the two time series intersect:…
yoshiserry
  • 20,175
  • 35
  • 77
  • 104
5
votes
1 answer

c3js bar width not adjusting to the zooming

The chart is pretty good when it is normal. but i expect it to adjust the bar width upon zoom. The graph without zoom is as below. when I zoom into the graph, the bars width remains same, very thin! Is there anyway that they auto adjust? I saw a…
Vishal Sharma
  • 2,550
  • 1
  • 23
  • 40
5
votes
2 answers

Pandas scatterplot categorical and timeseries axes

I'm looking to create a chart much like nltk's lexical dispersion plot, but am drawing a blank how to construct this. I was thinking that scatter would be my best geom, using '|' as markers, and setting the alpha, but I am running into all sorts of…
hyleaus
  • 755
  • 1
  • 8
  • 21
5
votes
2 answers

How to change line properties in ggplot2 halfway in a time series?

Take the following straightforward plot of two time series from the economics{ggplot2} dataset require(dplyr) require(ggplot2) require(lubridate) require(tidyr) economics %>% gather(indicator, percentage, c(4:5), -c(1:3, 6)) %>% mutate(Y2K =…
TemplateRex
  • 69,038
  • 19
  • 164
  • 304
5
votes
2 answers

How can I add a new line to jquery flot ticks

I am using JQuery Flot to create some graphs. So far I have managed to format my Ticks using tickformatter The graph looks like this: http://i1358.photobucket.com/albums/q779/Angel_Ruiz_Morales/Capture.gif The only problem I am having now is that I…
Angel
  • 543
  • 5
  • 13
4
votes
2 answers

In plotly, is it possible to have an action where a user clicks and sees a different time range in the chart?

I'm creating a plotly python chart for a web app. Right now I am using the 'rangeselector' option to display different views to go back 7 days, 14 days, etc. However - what I actually want is a way to show the data for "this week", "last week", "the…
user2154589
  • 49
  • 9
4
votes
3 answers

How to plot a simple lineplot in SAS

My data are structured as follows (these are just sample data as the original data are secret) id | crime | location | crimedate ------------------------------ 1 | Theft | public | 2019-01-04 1 | Theft | public | 2019-02-06 1 | Theft …
D. Studer
  • 1,711
  • 1
  • 16
  • 35
4
votes
0 answers

Plotly: Add colorscale in multiple lines plot using Python

Summary I want to add colorscale to multiple lines chart using plotly-python (plotly==3.7.1). I don't want to declare each color hex manually. The years should order the colormap (ex: 2000 is soft blue ... 2018 is dark blue) Currently…
Filipe Filardi
  • 170
  • 2
  • 12
4
votes
1 answer

Set zero for missing data in echarts.js

I want to combine 2 or more line charts having dates in x-axis and values in y-axis. But the dates for some series do not match. series0X= ["2015-11-21","2017-09-21"]; series1X= ["2017-09-21","2017-10-22","2017-11-20"]; series2X=…
Nunaram Hembram
  • 51
  • 1
  • 5
4
votes
1 answer

How to plot multiple series/lines in a time series using plotly in R?

I have a time series of several years that I need to plot mm/dd on the x-axis and multiple years on the y-axis using plot_ly. I have generated a sample data here: date<-seq(as.Date("2010-11-22"),as.Date("2016-05-26"),by ="days") sales = runif(2013,…
Ankit Gupta
  • 49
  • 1
  • 3
4
votes
2 answers

Plotting period series in matplotlib pyplot

I'm trying to plot timeseries revenue data by quarter with matplotlib.pyplot but keep getting an error. Below is my code and the errors The desired behavior is to plot the revenue data by quarter using matplotlib. When I try to do this, I…
oammon
  • 189
  • 1
  • 4
  • 12
4
votes
1 answer

Plotting time on y-axis and date on x-axis d3.js

Image of the chart var cValue = function(d) { return d.date; }, color = d3.scale.category10(); var data = [{ "date": "30-Dec-16", "time": "Mon Dec 30 2016 16:29:23 GMT+0530 (India Standard Time)", "close": "30" }, …
user3240203
  • 43
  • 1
  • 4
4
votes
2 answers

Alternatives for using forEeach() loop while converting data for D3.js

I am still struggling with this error as indicated in this earlier post on StackOverflow.com. I have isolated the cause of the problem, which is in my D3.js code it is unable to iterate through an 'object'. My raw data source is a RESTful web api.…
WebFixItMan
  • 231
  • 2
  • 9
1
2
3
…
26 27