Python Matplotlib - Smooth plot line for x-axis with date values -


im trying smooth graph line out since x-axis values dates im having great trouble doing this. have dataframe follows 

import matplotlib.pyplot plt import numpy np import pandas pd %matplotlib inline  startdate = '2015-05-15' enddate = '2015-12-5' index = pd.date_range(startdate, enddate) data = np.random.normal(0, 1, size=len(index)) cols = ['value']  df = pd.dataframe(data, index=index, columns=cols)

then plot data

fig, axs = plt.subplots(1,1, figsize=(18,5)) x = df.index y = df.value axs.plot(x, y) fig.show()

we get

enter image description here

now smooth line there usefull staekoverflow questions allready like:

but cant seem code working example, suggestions?

you can use interpolation functionality shipped pandas. because dataframe has value every index already, can populate index more sparse, , fill every non-existent indices nan values. then, after choosing 1 of many interpolation methods available, interpolate , plot data:

index_hourly = pd.date_range(startdate, enddate, freq='1h') df_smooth = df.reindex(index=index_hourly).interpolate('cubic') df_smooth = df_smooth.rename(columns={'value':'smooth'})  df_smooth.plot(ax=axs, alpha=0.7) df.plot(ax=axs, alpha=0.7) fig.show()

enter image description here


Comments

Post a Comment

Popular posts from this blog

sql - can we replace full join with union of left and right join? why not? -

can replace full join union of left , right join? if no,why? 'yes' if t1 , t2 sets (no duplicated rows), otherwise answer 'no'. create table t1 (i int); create table t2 (i int); insert t1 values (1); insert t1 values (2); insert t1 values (2); insert t2 values (3); full join select * t1 full join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 2 2 (null) 3 union select * t1 left join t2 on t1.i=t2.i union select * t1 right join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 (null) 3 union all select * t1 left join t2 on t1.i=t2.i union select * t1 right join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 2 2 2 2 2 2 (null) 3
Read more

javascript - Parallax scrolling and fixed footer code causing width issues -

i bolted bits of code. 1 parallax scrolling, , other piece of fixed footer code found here: http://codepen.io/madshaakansson/pen/cgjch though after bolting , fixing few issues, have problem different widths. header different width footer, , main content doesnt span whole width of page. have tried adjusting width of content css 100%, made main content span whole width, ended breaking footer. i not sure need change make these different bits of code work together. advice appreciated. my attempt: http://codepen.io/dingerzat/pen/qgbwkk html /*global define: false */ function init() { window.addeventlistener('scroll', function(e) { var distancey = window.pageyoffset || document.documentelement.scrolltop, shrinkon = 300, header = document.queryselector("header"); if (distancey > shrinkon) { classie.add(header, "smaller"); } else { if (classie.has(header, ...
Read more

iOS: Performance of reloading UIImage(name:...) -

i have tableview , each row has icon. 90% of rows have same icon. in cellforrowatindexpath method load image assets folder this: var cellimage = uiimage(named: "myimage") does pose performance problem? os somehow smart enough it's same image each time? better if loaded image once , saved in class variable , assigned each time? uiimage 's named: api does kind of caching. if @ uiimage's documentation , states: use init(named:in:compatiblewith:) method (or init(named:) method) create image image asset or image file located in app’s main bundle (or other known bundle). because these methods cache image data automatically, recommended images use frequently.
Read more