摘要: 1. remove non alpha and replace space with '_' VBA insert module: Function CleanCode(Rng As Range) Dim strTemp As String Dim n As Long trim_Rng = Trim 阅读全文
posted @ 2017-09-12 16:23 付小同 阅读(179) 评论(0) 推荐(0) 编辑
摘要: 什么是线性回归? y = f(x), a function that representing the relationship between input x and output y. The Function we used here is the general Linear Functio 阅读全文
posted @ 2017-08-15 23:54 付小同 阅读(178) 评论(0) 推荐(0) 编辑
摘要: 1. Confusion Matrix A confusion table for Class A Positive/ Negative: if target class is A, then the predict A is Positve, Others are negative. True ( 阅读全文
posted @ 2017-07-16 11:10 付小同 阅读(596) 评论(0) 推荐(0) 编辑
摘要: 1. read line from file #!/bin/bash##example: my_read_file.sh input.csv# max_level=0max_line="" #loop read line while read line || [ -n "$line" ]#read 阅读全文
posted @ 2017-06-06 12:21 付小同 阅读(260) 评论(0) 推荐(0) 编辑
摘要: Feature Selection Why 1.curse of dimensionality Method 1. Filter: Scoring each feature, filter out good features. (Information Content) 1.1 Chi-Square 阅读全文
posted @ 2017-05-12 11:57 付小同 阅读(238) 评论(0) 推荐(0) 编辑
摘要: 介绍 我们有一些历史数据: record id\attributes 根据这些数据,我们想回答: If we got a record 4, that is 'a1,b1,c2', is record4 Good or Bad? 解决方法 我们要分别考量record4的三个属性的先验(Priori) 阅读全文
posted @ 2017-05-07 22:06 付小同 阅读(283) 评论(0) 推荐(0) 编辑
摘要: 1. Syntax http://www.w3school.com.cn/xpath/xpath_syntax.asp Selection 选取根元素 bookstore。 注释:假如路径起始于正斜杠( / ),则此路径始终代表到某元素的绝对路径! Predicate WildCard 2. 阅读全文
posted @ 2017-05-05 11:58 付小同 阅读(274) 评论(0) 推荐(0) 编辑
摘要: 1. Save output of command as a file, append date /app/etl/DEV/appl/log2/xxx_$(date +"%Y%m%d").log 2. parameters Env 3.output parameters echo $<para> 4 阅读全文
posted @ 2017-05-02 09:58 付小同 阅读(168) 评论(0) 推荐(0) 编辑
摘要: 1. Admin Perm Space: Store Tables Spool Space: Temp table in Executing Temp Space: Global Temp 2.Data Distribution Hash(PI(Primary Index)) -> AMP(virt 阅读全文
posted @ 2017-04-27 18:20 付小同 阅读(182) 评论(0) 推荐(0) 编辑
摘要: python with data science: https://campus.datacamp.com/courses/intro-to-python-for-data-science/chapter-1-python-basics?ex=1 machine learning coursera: 阅读全文
posted @ 2017-04-21 13:35 付小同 阅读(313) 评论(0) 推荐(0) 编辑