Amanda'blog

Friday, July 26, 2013

excel 挑选数据 的语句

=IF(OR(ABS(C2)>1,ABS(D2)>1),1,0)

挑选 C列或者D列 大于1的 行。满足条件的 标为1,不满足的标为 0
Posted by Amanda.xin.wen at 8:43 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

matlab 建立 heatmap

建立workspace  ***


把excel的数据贴到matlab的table里面


运行语句 Heatmap(***)


done

如下图


Posted by Amanda.xin.wen at 8:41 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2019 (2)
    • ►  June (1)
    • ►  January (1)
  • ►  2015 (7)
    • ►  April (1)
    • ►  February (3)
    • ►  January (3)
  • ►  2014 (8)
    • ►  December (2)
    • ►  April (5)
    • ►  March (1)
  • ▼  2013 (20)
    • ►  October (2)
    • ▼  July (2)
      • excel 挑选数据 的语句
      • matlab 建立 heatmap
    • ►  April (1)
    • ►  March (5)
    • ►  February (5)
    • ►  January (5)

About Me

Amanda.xin.wen
View my complete profile
Simple theme. Powered by Blogger.