python - Pandas graphing a timeseries, with vertical lines at selected dates -


consider timeseries, cumulative number of edits in wikipedia category. 

in [555]: cum_edits.head() out[555]: 2001-08-31 23:37:28    1 2001-09-01 05:09:28    2 2001-09-18 10:01:17    3 2001-10-27 06:52:45    4 2001-10-27 07:01:45    5 name: edits, dtype: int64 in [565]: cum_edits.tail() out[565]: 2014-01-29 16:05:15    53254 2014-01-29 16:07:09    53255 2014-01-29 16:11:43    53256 2014-01-29 18:09:44    53257 2014-01-29 18:12:09    53258 name: edits, dtype: int64

i have graph so:

in [567]:  cum_edits.plot()  out[567]:  <matplotlib.axes.axessubplot @ 0x1359c810>

cummulative edits

i plot vertical lines, after every total_edits/n ; e.g. n=10 edits. calculate these easily.

in [568]:  dates  out[568]:  [timestamp('2006-06-04 04:46:22', tz=none),  timestamp('2007-01-28 23:53:02', tz=none),  timestamp('2007-09-16 10:52:02', tz=none),  timestamp('2008-04-28 21:20:40', tz=none),  timestamp('2009-04-12 22:07:13', tz=none),  timestamp('2010-04-09 18:45:37', tz=none),  timestamp('2011-03-28 23:38:12', tz=none),  timestamp('2012-05-24 13:44:35', tz=none),  timestamp('2013-03-05 17:57:29', tz=none),  timestamp('2014-01-29 16:05:15', tz=none)]

normally 1 can use axvline() although encounter 2 problems. if call plt.axvline(x=0.5, color='r') produce arbitrary line, not see on top of pandas plot. using ipython %pylab inline way. , secondly, not how translate dates x position being used in cum_edits.plot() since translation invisible me. should go producing these vertical lines?

thanks @tomaugspurger

the solution axes back, , use ax.vlines.

ax = cum_edits.plot() ymin, ymax = ax.get_ylim() ax.vlines(x=dates, ymin=ymin, ymax=ymax-1, color='r')

solutions vlines

one last niggle if vlines ymax long, matplotlib adds space top of plot, reduce length less original axes, why see ymax=ymax-1.


-

Comments

Post a Comment

Popular posts from this blog

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

sql - Select Query has unexpected multiple records (MS Access) -

i may tired, can't seem figure out happening. have 2 queries. query 1 has 10 fields. query 2 has 5 fields. fields 1 through 3 same in both queries. trying write select query , simple add field 5 query2 query1 result should query1 additional field (query2.field5). i join first 3 fields both queries , choose select records in query1 , in query2 match. don't know sql, use query designer. expect same number of records have query 1 instead have 3 times or more. can tell me doing wrong. tried reversing joins still seem same records. thanks in advance. here query: the fields in common divisionname , supplierid = vendorid , commodityname . select [part revenue exposed query p1].divisionname, [part revenue exposed query p1].commodityname, [part revenue exposed query p1].suppliername, [part revenue exposed query p1].partnumber, [part revenue exposed query p1].partdescription, [part revenue exposed query p1].bucode, ...
Read more