Exploratory Hour #57 - 括弧の中のテキストを取り出したい

81c7a276a2c5944a9b8bdd9cc1a43250?s=47 Takato Shiroto
January 14, 2020
Technology
0
27

Exploratory Hour #57 - 括弧の中のテキストを取り出したい

2020/1/14に行ったExploratory Hourのスライドです。

特定の値を抽出できるstr_extract関数の使い方を紹介しています。

Exploratory Hourで紹介した機能については、下記をご覧ください。

https://exploratory.io/tag/?q=tag:Exploratoryhour

81c7a276a2c5944a9b8bdd9cc1a43250?s=128

Takato Shiroto

January 14, 2020
Tweet

More Decks by Takato Shiroto

See All by Takato Shiroto
81c7a276a2c5944a9b8bdd9cc1a43250?s=48 takatoshiroto
0
11
81c7a276a2c5944a9b8bdd9cc1a43250?s=48 takatoshiroto
0
10
81c7a276a2c5944a9b8bdd9cc1a43250?s=48 takatoshiroto
0
62
81c7a276a2c5944a9b8bdd9cc1a43250?s=48 takatoshiroto
0
14
81c7a276a2c5944a9b8bdd9cc1a43250?s=48 takatoshiroto
0
5
81c7a276a2c5944a9b8bdd9cc1a43250?s=48 takatoshiroto
0
11
81c7a276a2c5944a9b8bdd9cc1a43250?s=48 takatoshiroto
0
17
81c7a276a2c5944a9b8bdd9cc1a43250?s=48 takatoshiroto
0
130
81c7a276a2c5944a9b8bdd9cc1a43250?s=48 takatoshiroto
0
20

Other Decks in Technology

See All in Technology
3dc29e8cfc6ef333e2b41a1b0e826b57?s=48 cortinico
5
260
69f5ab96892df4d8cbe32189f2ed2d9d?s=48 heyinc
2
12k
5b47136bedcba2799edf4fcd27ea66d7?s=48 yaegashi
0
320
881b1b57f1cbe3b66b017203f7cb2efb?s=48 nplusone
0
230
9c42c4bc1d91c409d754da88c91cb2ef?s=48 kur0cky
1
230
Cd6e67775ba3275c466e9927ede23080?s=48 nk35jk
2
1.3k
A857277d74d4719f7f7751dca5ed553e?s=48 cmusudakeisuke
0
1.4k
229b1596ce57cd0935a2bacd410d87a0?s=48 aaaddress1
1
1.2k
80c79a9d024d1e1a253893a78189ce6d?s=48 ujnak
1
140
470bbf16e3547a17e40c34da937be921?s=48 kikmysy4
0
150
6557f271a0b301f453f773be43cf876f?s=48 miyamoto_hiroki
1
200
893dd6e1aa73c35621327c385cb27207?s=48 konnnnnok
0
130

Featured

See All Featured
78b475797a14c84799063c7cd073962f?s=48 holman
287
130k
761be20b5ebd271008bcee1244fc5b52?s=48 matthewcrist
70
7k
4394ceb8b277f35ee3da7030384efb5d?s=48 davidbonilla
68
3.4k
C86443373fbfe92996aa882d0d7a59f8?s=48 imathis
477
150k
F68cb25ae3e5c2106997454b13b7737d?s=48 brad_frost
154
6.1k
B3d6434763caa0ef5dc4b792662c49f7?s=48 smashingmag
281
46k
1519587b1a0febb658c36c94f6272b0d?s=48 roundedbygravity
240
20k
20bfe76b3d6105641f879fe45cfc9272?s=48 bkeepers
319
53k
B47b288784fda77a94aeb234ca743c24?s=48 keavy
102
14k
Aebc2d07a50011e2a30d38435fde564a?s=48 jrom
113
6.8k
027d1ebf66cc039a0bd3b55eeadbe75d?s=48 sachag
266
16k
8081b26e05bb4354f7d65ffc34cbbd67?s=48 chriscoyier
775
240k

Transcript

  1. EXPLORATORY 1

  2. 2 εϐʔΧʔ നށ ܟొ Customer Succes EXPLORATORY ུྺ େֶࡏֶதʹϑʔυϩεΛݮΒͨ͢ΊʹɺֶੜஂମΛ্ཱͪ͛୅දΛ ຿ΊΔɻͦͷޙɺϏδωεΛ஌ΔͨΊʹԽֶϝʔΧʔͷσϡϙϯͱ

    ϑʔυςοΫܥελʔτΞοϓͰӦۀͱϚʔέςΟϯάΛܦݧɻΞϓ Ϧͷ੒௕ͷͨΊʹ͸σʔλαΠΤϯε͕ඞཁͩͱײ͡ɺΞϓϦʹಛԽ ͨ͠Ϣʔβʔͷߦಈ෼ੳπʔϧΛ։ൃ͢ΔاۀʹͯɺΞϓϦۀքͷ KPI෼ੳͳͲΛ୲౰͢Δɻݱࡏ͸Exploratory, Inc. ͰΧελϚʔαΫη εΛ୲౰͢Δ๣ΒɺσʔλͷՄࢹԽͱ୳ࡧతσʔλ෼ੳΛઐ໳ͱͯ͠ σʔλαΠΤϯεͷීٴʹऔΓ૊Ήɻ @ShirotoTakato

  3. Exploratory Hour

  4. • ސ٬͝ͱʹલճͷߪങ೔͔Β࣍ͷߪങ೔·ͰͷظؒΛٻΊ͍ͨ • ಛఆͷ੡඼ͷച্߹ܭΛࠃ͝ͱʹूܭ͍ͨ͠ • ׅހͷதͷςΩετΛऔΓग़͍ͨ͠ ࠓिͷ࣭໰

  5. • ސ٬͝ͱʹલճͷߪങ೔͔Β࣍ͷߪങ೔·ͰͷظؒΛٻΊ͍ͨ • ಛఆͷ੡඼ͷച্߹ܭΛࠃ͝ͱʹूܭ͍ͨ͠ • ׅހͷதͷςΩετΛऔΓग़͍ͨ͠ ࠓिͷ࣭໰

  6. ച্σʔλ

  7. ׅހͷதͷςΩετΛऔΓग़͍ͨ͠

  8. Date_colͷྻ͔ΒςΩετσʔλͷՃ޻Λબͼɺநग़͢ΔΛબ୒͢Δ

  9. ςΩετσʔλͷՃ޻ͷμΠΞϩά͕։͔ΕΔ

  10. …ͷதͷςΩετΛબͼɺ։࢝ͱ຤ඌʹׅހΛೖྗ͢Δ

  11. ؔ਺ͱࢦఆͨ͠Ҿ਺͕දࣔ͞ΕΔ

  12. ϓϨϏϡʔΛΫϦοΫͯ͠ɺ৽͍͠஋Λ֬ೝ͢Δ

  13. ׅހͷதͷςΩετΛऔΓग़͢͜ͱ͕Ͱ͖ͨ

  14. σʔλλΠϓΛ೔෇ܕʹม׵͢Δ

  15. σʔλλΠϓΛ೔෇ܕʹม׵͢Δ

  16. σʔλλΠϓΛ೔෇ܕʹม׵͢Δ͜ͱ͕Ͱ͖ͨ

  17. Appendix

  18. UIͷཪͰؔ਺͕ࣗಈͰੜ੒͞Ε͍ͯΔ

  19. ؔ਺Λબ୒ͯ͠ίϐʔ͢Δ

  20. εςοϓϝχϡʔ͔ΒܭࢉΛ࡞੒Λબ୒͢Δ

  21. ܭࢉΤσΟλʹϖʔετ͢Δ

  22. ࣮ߦ͢Δͱstr_extractؔ਺͕ద༻͞Εͨ͜ͱ͕Θ͔Δ

  23. Contact Email takato@exploratory.io Twitter Hashtag #ExploratoryHour ͰπΠʔτʂ Twitter @ExploratoryJp Exploratory

    Hour https://bit.ly/30odd9q