全部版块 我的主页
论坛 数据科学与人工智能 数据分析与数据科学 R语言论坛
1329 2
2013-11-14
dncp600.xls
大小:(29.5 KB)

 马上下载



Dear,

I would like to make a plot of CP vs TIME by using median value of CP at each time point. However, I am thinking to bin the time points to the following points:

0.25, 0.5, 1, 1.5, 2, 2.5, 3, 4, 6, 8, 12, 24

instead of the time points in the dataset. But still keep the concentration. Is there a way to do it? Thanks a lot!


二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

全部回复
2013-11-14 20:51:24
复制代码
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2013-11-15 21:14:55
Generally speaking you may want to include a column for scheduled sampling time in your dataset for later processing. In your case you can simply round your actual sampling time to get the scheduled ones ASSUMING NO LARGE DEVIATIONS FROM YOUR SAMPLING SCHEME. Otherwise there is no way to do it. Check your data carefully before doing that, e.g.

复制代码

The next step will be calculating median of your concentration data grouped by scheduled time.

复制代码

Now you have every thing you need for the plot. I still suggest you to do your plot using actual sampling time even though the medians are calculated per scheduled time.

复制代码

Results:
Ct_orig.png

As your actual time is quite close to the schedule in my approach. There will be little difference if you plot using schedule time.
For comparison:

Ct_schd.png

二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群