by shigemk2

当面は技術的なことしか書かない

awscli 1.15.66

1.15.66

  • api-change redshift Update redshift command to latest version
  • api-change greengrass Update greengrass command to latest version
  • api-change ssm Update ssm command to latest version
  • api-change ec2 Update ec2 command to latest version
  • api-change inspector Update inspector command to latest version
  • api-change codebuild Update codebuild command to latest version

Release 1.15.66 · aws/aws-cli · GitHub

a1 notation

a1 notation

なんのことかと思ったら表記法だった シート名は日本語もOK 絵文字は知らない

表記 範囲
Sheet1!A1:B2 Sheet1のA1 A2 B1 B2
Sheet1!A:A Sheet1のA列全部
Sheet1!1:2 Sheet1の1行目と2行目全部
Sheet1!A5:A Sheet1のA列 5行目から下全部
A1:B2 最初のシートのA1 A2 B1 B2
Sheet1 Sheet1全部

https://developers.google.com/sheets/api/guides/concepts#a1_notation

beautifulsoup findAll

要素を配列に突っ込みながら、Lambdaでフィルタリングもできる

soup.findAll(text="one")
# [u'one']
soup.findAll(text=u'one')
# [u'one']

soup.findAll(text=["one", "two"])
# [u'one', u'two']

soup.findAll(text=re.compile("paragraph"))
# [u'This is paragraph ', u'This is paragraph ']

soup.findAll(text=True)
# [u'Page title', u'This is paragraph ', u'one', u'.', u'This is paragraph ',
#  u'two', u'.']

soup.findAll(text=lambda(x): len(x) < 12)
# [u'Page title', u'one', u'.', u'two', u'.']

https://tdoc.info/beautifulsoup/