We have many sql alike code to patch the system. The purpose is to clean the code to do two things: 1) to find what variables are used; 2) to find the value used in the code. That is, transfer to key-value form so that it can …
export day=2019-06-02
#day=$(date +%Y-%m-%d)
sunday_1=$(date -d "$day -$(date -d $day +%w) days" +%Y-%m-%d) # last sunday include current date
sunday_2=$(date -d "$day -$(date -d $day +%u) days" +%Y-%m-%d) # last sunday not include current date …python regular expression to clean the RMP data.
import re
strtest = """ 3602433631519" /> </td>
<td> 7 </td>
<td>< = "> </a></td>
<td>HRB_HighClaim_Sideline</td>
<!-- Align Rule condition to variable expression -->
<td></td>
<td>MVEL</td>
<td>
<pre class="code">get("$BFS.hrb_claims_by_customer_us.n_claim_count")!\
=empty &&
get("$var_001" …awk -F, '{OFS="\t";print $3,$4}' mo_orders_weekly_2019-04-27.txt ==> awk '{print $4","$5}' mo_orders_weekly_2019-04-27.txt
cat mo_orders_weekly_2019-04-27.txt | cut -d ',' -f3 ==> cat mo_orders_weekly_2019-04-27.txt | cut -f3-4
awk -F, '{OFS=",";print $1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$20,$21}' infile.csv > outfile.csv
something else to consider …
linux tree display: use LC_ALL=C tree to display the directory structure in tree format. By default tree may give weired strings. Need LC_ALL=C to change to default language.
RHEL 6 - how to install 'GLIBC_2.14' or 'GLIBC_2.15'?: when install lightgbm in RHEL 6, it asks for intall GLIBC_2.14 to execute the software is built in RHEL 7 and try to run on RHEL 6.
从信用卡欺诈模型看不平衡数据分类：这个作者总结了kaggle上面不同的人使用不同的抽样办法，不同的模型，以及异常值检验的办法。我以前也做过这 …
convert dataframe other types: df.dtypes, df.astype(str), df.astype(float), df.astype('category'), df.astype('object')
ValueError: If using all scalar values, you must pass an index
df = pd.DataFrame({'A': [1], 'B': [2]}) or df = pd.DataFrame({'A': 1, 'B': 2}, index=[0])