Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Digital Hack Day 2022 オフィス不動産データ説明

Digital Hack Day 2022 オフィス不動産データ説明

2022 ヤフー株式会社主催のDigital Hack Day2022に提供するオフィス不動産データに関する説明資料です。
https://hackday.yahoo.co.jp/

estie | エスティ

August 22, 2022
Tweet

More Decks by estie | エスティ

Other Decks in Technology

Transcript

  1. %JHJUBM)BDL%BZ
    ΦϑΟεෆಈ࢈σʔλͷ͝આ໌

    View full-size slide


  2. ࣗݾ঺հ
    ੨໦ ৴ʢ͓͖͋͠Μʣ
    גࣜձࣾFTUJF71PG&OHJOFFSJOH
    • dਓ໨ͷ։ൃ෦໳ࣾһͱ
    ͯ͠ೖࣾ
    • ࠷ۙ͸ɺ࠾༻ٕज़޿ใ੍౓ӡ༻
    43&σʔλ෼ੳج൫ ͋ͨΓ
    • ೖࣾલཧֶ෦਺ֶՊˠΞΫηϯνϡ
    Ξσδλϧ
    • 🦔ͷFSJ[Pͱ฻Β͍ͯ͠·͢

    View full-size slide

  3. גࣜձࣾFTUJF

    ձ໊ࣾ גࣜձࣾFTUJFʢΤεςΟʣ
    ॴࡏ஍ ౦ژ౎ߓ۠੢৽ڮஸ໨೔ൺ୩ϑΥʔτλϫʔ
    ઃཱ ೥݄
    ࢿຊۚ ԯԁ
    ୅දऔక໾ ฏҪ ӯ
    גओ ܦӦਞ
    ౦ژେֶΤοδΩϟϐλϧύʔτφʔζʢ65&$ʣ
    άϩʔϏεɾΩϟϐλϧɾύʔτφʔζʢ($1ʣ
    άϩʔόϧɾϒϨΠϯ
    ٕज़ސ໰ ౉ล ౒ʢ౦ژେֶେֶӃܦࡁֶݚڀՊڭतɺφ΢Ωϟετ૑ۀऀʣ
    ձࣾ֓ཁ

    View full-size slide

  4. FTUJFͷϝϯόʔʹ͍ͭͯ

    ࡾඛ஍ॴͰւ֎ࢢ৔ʹ͓͚Δෆಈ࢈౤ࢿӡ༻
    Λ୲౰ޙɺ౦ژͷΦϑΟεӦۀ։ൃΛܦݧ
    ελʔτΞοϓ޲͚ͷΠϯΩϡϕʔγϣϯΦ
    ϑΟεͷ৽ن։ൃ΍ϕϯνϟʔΩϟϐλϧ΁ͷ
    -1౤ࢿ౳ʹैࣄ
    ฏҪ ӯ
    ୅දऔక໾$&0
    *OEFFE+BQBOʹͯٻਓืूσʔλͷऔಘͱఏ
    ڙΛ໨తͱͨ͠ύΠϓϥΠϯͷ։ൃʹैࣄɻֶ
    ੜ࣌୅ʹ͸ϓϩάϥϛϯάڭҭڭࡐͷ։ൃͰى
    ۀܦݧ͋Γ
    FTUJFͰ͸$50΁ब೚͠ɺ։ൃνʔϜΛ౷ׅ
    ؠ੒ ୡ࠸
    औక໾$50
    ࡾඛ஍ॴͷܦཧ෦Ͱ࿈ܾ݁ࢉ΍."Λ୲౰ޙɺ
    3PDLFGFMMFS(SPVQʹग़޲͠ɺถࠃͰΦϑΟε
    ΍෺ྲྀࢪઃΛத৺ʹෆಈ࢈౤ࢿʹैࣄ
    ϗςϧܥελʔτΞοϓͷऔక໾ΛܦͯFTUJF
    ʹδϣΠϯ͠ɺݱࡏ͸Ϗδωε෦໳Λ౷ׅ
    ଋݪ ༔ޗ
    औక໾
    ෆಈ࢈ܥاۀग़਎ͷ໊ͱςοΫܥاۀग़਎ͷ໊ͰܦӦ

    View full-size slide

  5. FTUJFͷϝϯόʔʹ͍ͭͯ

    &OHJOFFS

    %FTJHOFS

    1E.

    #VTJOFTT

    $PSQPSBUF

    .BOBHFNFOU

    ೥݄࣌఺
    ໊ࡏ੶
    3FBM&TUBUF 5FDIOPMPHZ
    ෆಈ࢈اۀग़਎ऀͱςοΫاۀग़਎ऀ͕ࡏ੶͢ΔϋΠϒϦουͳνʔϜ
    ϓϩμΫτ։ൃਓһ͕ଟ͍ͷ͕ಛ௃త

    View full-size slide


  6. ೔ຊ࠷େڃͷΦϑΟεσʔλ
    ϓϥοτϑΥʔϜαʔϏε

    View full-size slide

  7. ࣗ෼ͷΦϑΟεͷ௞ྉ͸
    ͍͘Β͔෼͔Γ·͔͢ʁ

    View full-size slide

  8. Ͱ͸ɺྡͷϏϧͷ
    ௞ྉ͸஌͍ͬͯ·͔͢ʁ

    View full-size slide


  9. ʁ
    ࣮͸ɺϏϧΦʔφʔ΍ϑΝϯυͳͲ

    View full-size slide





  10. ౎৺ͷΦϑΟεϏϧͷ͏ͪ
    ΢ΣϒͰ௞ྉ͕෼͔Δͷ͸
    Θ͔ͣ
    4PVSDF౰ࣾσʔλɺେखෆಈ࢈ձࣾ΢ΣϒαΠτ

    View full-size slide


  11. ϏϧΦʔφʔ͸
    ࣾ΄Ͳͷ஥հձࣾʹରͯ͠
    ࢴɺ1%'ɺର໘Ͱۭࣨ৘ใڞ༗

    View full-size slide


  12. ࣾ΋ͷΦʔφʔ͔Β΋Β͏
    େྔͷۭࣨ৘ใΛࡹ͚ͳ͍ɾɾɾ

    View full-size slide


  13. ໢ཏతͳσδλϧσʔλ͕ଘࡏ͠ͳ͍

    View full-size slide


  14. ۭࣨ৘ใͷྲྀ௨ߏ଄͕ߗ௚తͰ
    ଟେͳ࿑ྗΛ͔͚ͯ΋࠷దͳΦϑΟεʹग़ձ͑ͳ͍
    ඇৗʹݶΒΕͨ৘ใ͚ͩͰ
    ҠసͷҙࢥܾఆΛڧ͍ΒΕΔ
    ͔ࣾΒ΋Β͏
    େྔͷۭࣨ৘ใΛࡹ͚ͳ͍
    ࣾ΄Ͳͷ஥հձࣾʹ
    ࢴɺ1%'Ͱۭࣨڞ༗
    ʷ
    ʷ
    ஥հձࣾ
    ςφϯτاۀ
    ϏϧΦʔφʔ؅ཧձࣾ

    View full-size slide


  15. ೔ຊ࠷େڃͷϓϥοτϑΥʔϜʹΑΓ
    τϥϯβΫγϣϯΛՃ଎͠ϛεϚονΛͳ͘͢
    ྲྀಈੑͷߴ͍ࣄۀऀؒ
    ৘ใωοτϫʔΫʹΑΓ
    ࠷దͳΦϑΟεʹग़ձ͏
    ืू৘ใͷޮ཰తऩू
    Ӧۀ׆ಈͷσδλϧԽଅਐ
    σʔλΛ׆༻ͨ͠
    ΦϑΟε௞ିۀߴ౓Խ
    ςφϯτاۀ
    ϏϧΦʔφʔ؅ཧձࣾ
    ஥հձࣾ

    View full-size slide


  16. ϦΞϧΞηοτͷσʔλɺۀ຿৘ใͷਖ਼نԽ͸ͱͯ΋೉͍͠
    ʁ

    View full-size slide

  17. ಋೖاۀྫʢҰ෦ൈਮɾԻॱʣ

    View full-size slide

  18. ఏڙٕज़ͷ঺հ

    ݐ෺৘ใ
    શࠃ໿ສ౩௒ͷ෺݅جૅ৘ใ
    ςφϯτ৘ใ
    ౦ژ۠ͷສ݅Ҏ্ͷೖډσʔλ
    কདྷڙڅ
    શࠃͷΦϑΟεϏϧ৽نڙڅσʔλ
    σʔλఏڙגࣜձࣾθϯϦϯ

    View full-size slide

  19. ఏڙσʔλͷৄࡉ

    詳細な項⽬情報
    https://docs.google.com/spreadsheets/d/1N03FFduu322NpqIRRtlJb8_s7ybDu84HJfQfssd8vPw/edit?usp=sharing

    View full-size slide

  20. 提供データの詳細
    # テーブル⼀覧 概要
    1 buildings 物件情報
    2 building_stations 最寄駅
    3 stations 駅
    4 lines 路線
    5 station_lines 路線と駅のリレーション
    6 occupiers ⼊居者・テナント
    7 occupier_buildings ⼊居情報
    詳細な項⽬情報
    https://docs.google.com/spreadsheets/d/1N03FFduu322NpqIRRtlJb8_s7ybDu84HJfQfssd8vPw/edit?usp=sharing

    View full-size slide


  21. σʔλར༻ͷਃ͠ࠐΈ
    • %JTDPSEʹ͓ૹΓ͢ΔϑΥʔϜΑΓ͓ਃ͠ࠐΈ͍ͩ͘͞

    View full-size slide


  22. ϦΞϧͳσʔλΛऔΓѻ͏ͷ͸೉͍͠ɺ͚ͩͲ໘ന͍
    過去の社外ハッカソンの事例
    https://inside.estie.co.jp/entry/2022/05/10/100000
    社内Data Scientistの取り組み
    https://inside.estie.co.jp/entry/2022/05/10/100000

    View full-size slide


  23. 5IBOLZPV
    FTUJF

    View full-size slide