onom: 10月 2020

2020年10月25日日曜日

EPS 2020OCT25

> eps_year_xts["2020::"]
[,1]
2020-01-01 116.33
2020-04-01 99.16
2020-07-01 93.44
2020-10-01 89.68
2021-01-01 110.65
2021-04-01 129.66
2021-07-01 139.84
2021-10-01 148.29

$ tac eps.txt | awk '{gsub("\\$","",$NF);print "eps_year_xts[\"2019::\"]["NR"] <- "$NF}'

eps_year_xts["2019::"][1] <- 134.39

eps_year_xts["2019::"][2] <- 135.27

eps_year_xts["2019::"][3] <- 132.90

eps_year_xts["2019::"][4] <- 139.47

eps_year_xts["2019::"][5] <- 116.33

eps_year_xts["2019::"][6] <- 99.23

eps_year_xts["2019::"][7] <- 93.03

eps_year_xts["2019::"][8] <- 87.16

eps_year_xts["2019::"][9] <- 101.75

eps_year_xts["2019::"][10] <- 119.53

eps_year_xts["2019::"][11] <- 128.19

eps_year_xts["2019::"][12] <- 135.75

for reference

$ cat eps.txt

12/31/2021 $44.69 $37.23 21.02 25.44 $164.30 $135.75

9/30/2021 $42.32 $36.45 22.20 26.94 $155.59 $128.19

6/30/2021 $40.10 $35.60 23.54 28.89 $146.68 $119.53

3/31/2021 $37.19 $26.47 25.89 33.94 $133.37 $101.75

12/31/2020 $35.98 $29.66 29.85 39.62 $115.68 $87.16

9/30/2020 (25.0%) 3363.00 $33.41 $27.79 29.05 37.12 $118.88 $93.03

6/30/2020 3100.29 $26.79 $17.83 24.75 31.24 $125.28 $99.23

3/31/2020 2584.59 $19.50 $11.88 18.64 22.22 $138.63 $116.33

12/31/2019 3230.78 $39.18 $35.53 20.56 23.16 $157.12 $139.47

9/30/2019 2976.74 $39.81 $33.99 19.46 22.40 $152.97 $132.90

6/30/2019 2941.76 $40.14 $34.93 19.04 21.75 $154.54 $135.27

3/31/2019 2834.40 $37.99 $35.02 18.52 21.09 $153.05 $134.39

2020年10月9日金曜日

awk tr sed mondate CLI download

1. download cli from this url

1.1 change downloaded file name to CLI3.csv

1.2 ~/R/R2/index/cli_download.sed run at the terminal.

sed -n '/USA/p' CLI3.csv |awk -F, '{print $6"-01,"$7}' |sed 's/\"//g' |awk 'BEGIN{print "DATE,DATA"}{print $0}' > usa.csv

# extract OECD entries and exclude OECDE

sed -n '/OECD[^E]/p' CLI3.csv |awk -F, '{print $6"-01,"$7}' |sed 's/\"//g' |awk 'BEGIN{print "DATE,DATA"}{print $0}' > oecd.csv

sed -n '/CHN/p' CLI3.csv |awk -F, '{print $6"-01,"$7}' |sed 's/\"//g' |awk 'BEGIN{print "DATE,DATA"}{print $0}' > chn.csv

sed -n '/EA19/p' CLI3.csv |awk -F, '{print $6"-01,"$7}' |sed 's/\"//g' |awk 'BEGIN{print "DATE,DATA"}{print $0}' > ea19.csv

sed -n '/JPN/p' CLI3.csv |awk -F, '{print $6"-01,"$7}' |sed 's/\"//g' |awk 'BEGIN{print "DATE,DATA"}{print $0}' > jpn.csv

1.3 run cli_load.r in R.

2.when cli is downloaded form this url

2.1. do as below in terminal change FILE_NAME accordingly.

grep "OECD - Total" <FILE_NAME>.csv | grep LOLITOAA |gawk -F, 'BEGIN{print "c("}{print $(NF-2)","}END{print ") " }' | tr -d "\n" | sed 's/,)/)/'

output is like

c(100.1448,100.0088,99.88226,99.7745,99.68903,99.62392,99.56622,99.5041,99.44289,99.39536,99.37106,99.38042,99.41794,99.46317,99.49193,99.47968,99.41767,97.69222,93.17708,94.81512,97.03869,98.08919,98.53291,98.79954)

> length(c(100.1448,100.0088,99.88226,99.7745,99.68903,99.62392,99.56622,99.5041,99.44289,99.39536,99.37106,99.38042,99.41794,99.46317,99.49193,99.47968,99.41767,97.69222,93.17708,94.81512,97.03869,98.08919,98.53291,98.79954) )

[1] 24

# start and end dates are fixed. caution!

seq( as.Date(mondate(Sys.Date())-24)-day(mondate(Sys.Date()))+1,as.Date(mondate(Sys.Date())-1),by='months' )

>seq( as.Date(mondate(Sys.Date())-24)-day(mondate(Sys.Date()))+1,as.Date(mondate(Sys.Date())-1),by='months' )

[1] "2018-10-01" "2018-11-01" "2018-12-01" "2019-01-01" "2019-02-01" "2019-03-01" "2019-04-01" "2019-05-01" "2019-06-01"

[10] "2019-07-01" "2019-08-01" "2019-09-01" "2019-10-01" "2019-11-01" "2019-12-01" "2020-01-01" "2020-02-01" "2020-03-01"

[19] "2020-04-01" "2020-05-01" "2020-06-01" "2020-07-01" "2020-08-01" "2020-09-01"

2.2. do as below in R

as.xts(c(100.1448,100.0088,99.88226,99.7745,99.68903,99.62392,99.56622,99.5041,99.44289,99.39536,99.37106,99.38042,99.41794,99.46317,99.49193,99.47968,99.41767,97.69222,93.17708,94.81512,97.03869,98.08919,98.53291,98.79954), seq( as.Date(mondate(Sys.Date())-24)-day(mondate(Sys.Date()))+1,as.Date(mondate(Sys.Date())-1),by='months' ))

2.3. alternatively do as below

grep "OECD - Total" <FILE_NAME>.csv | grep LOLITOAA |gawk -F, 'BEGIN{print "as.xts(c("}{print $(NF-2)","}END{print "), seq( as.Date(mondate(Sys.Date())-24)-day(mondate(Sys.Date()))+1,as.Date(mondate(Sys.Date())-1),by=\"months\" )) " }' | tr -d "\n" | sed 's/,)/)/'

2020年10月4日日曜日

mac addr DHCP LAN

58:E2:8F:22:5F:C0 iphone se
F8:4E:73:02:B7:6C (iPhone11onomoto) via br0 ?
34:A8:EB:81:58:4A ipad mini
F8:FF:C2:65:B5:0C macbook pro 16inch
78:4F:43:98:2F:8C macbook pro 15inch
00:1E:C2:A7:D3:EB macbook kuro
18:C2:BF:16:51:90 LS5110 NAS wired LAN
82:BA:85:04:AB:ED iphone 11 pro
74:75:48:1E:CD:4F kindle from mac address
00:F7:6F:CF:4E:E6 airmac express
58:55:CA:30:E6:4C apple tv
50:c4:dd:e9:70:b0 router

身元不明macアドレス

192.168.11.102 74:75:48:1E:CD:4F 31:15:20 kindle
192.168.11.110 72:8C:56:0F:7B:73

2020年10月3日土曜日

bash for and while

全てのcsvを0 length　にする。

$ for i in *.csv ; do cat /dev/null > $i; done

無限ループ。「while : (コロン）」で無限ループになる。

$ while : ; do echo 'hello'; sleep 10 ; done