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

68th Tokyo.R Beginner session1

68th Tokyo.R Beginner session1

第68回Tokyo.Rの初心者セッション1:data import/exportのスライドです。

kilometer

March 03, 2018
Tweet

More Decks by kilometer

Other Decks in Technology

Transcript



  1. @kilometer
    BeginneR Session 1
    -- Data Import / Export --
    2018.03.03 at Shiodome

    View Slide

  2. Who

    View Slide

  3. Who
    @kilometer
    Postdoc (Ph.D engineering)
    Animal Behavior
    Neuro Imaging
    Medical Engineering
    R ~ 10 years?

    :

    View Slide

  4. BeginneR Session

    View Slide


  5. View Slide


  6. View Slide

  7. Before After
    BeginneR Session

    View Slide

  8. Input
    Output
    Today’s talk
    ?
    ?
    Table data Image data Other formats
    Introduction Summary

    View Slide

  9. !
    #


    $"


    $

    $


    View Slide

  10. #
    %



    &$
    !&
    !&
    "







    View Slide


  11. !

    "

    "

    "


    View Slide


  12. !

    "

    "

    "


    View Slide

  13. Input
    Output
    Do NOT start from here

    View Slide

  14. Input
    Output
    Do NOT start from here
    Whatever

    View Slide

  15. Input
    Output
    Do NOT start from here
    Whatever

    1
    2
    3

    View Slide

  16. Input
    Output
    Today’s talk
    ?
    ?

    View Slide

  17. Integrated Development Environment
    RStudio https://www.rstudio.com/ !

    View Slide

  18. Integrated Development Environment
    RStudio https://www.rstudio.com/

    View Slide

  19. RStudio

    View Slide

  20. Projects
    RStudio

    View Slide

  21. RStudio > Project
    .H21474836474<:G RStudio
    7@
    ,R&-%("#+!')0FC
    ,')JA!3?
    ,')6=!("#+!3< RStudio!E1
    ฤू్தͷ಺༰Λอ࣋
    D5921474836472R*-$-QOL!;8/

    BI >
    34UVEJPͬͯͳΜͩʁ 1SPKFDUͬͯͳΜͩ
    !XBLVUFLB
    https://qiita.com/wakuteka/items/9599bb0a8985d98928d7

    View Slide

  22. RStudio > Project
    R

    +(
    .'"&
    #%"$
    RStudio)!

    *-
    , #%"&


    34UVEJPͬͯͳΜͩʁ 1SPKFDUͬͯͳΜͩ
    !XBLVUFLB
    https://qiita.com/wakuteka/items/9599bb0a8985d98928d7

    View Slide

  23. File > New Project… > New Directory > New Project
    hogehoge

    View Slide

  24. hogehoge
    ~/Documents/R
    hogehoge.Rproj
    .Rproj.user
    Project Root Directory
    Double click!!
    .RData
    .Rhistory
    Auto saved
    project information
    Open project
    New!!

    View Slide

  25. ~/Documents/R
    project1
    project2
    project3
    project4

    View Slide

  26. Input
    Output
    Today’s talk
    ?
    ?
    Table data Image data Other formats Summary
    Introduction

    View Slide

  27. Table format data
    Table data Image data Other formats
    Introduction Summary

    View Slide

  28. Table format data
    Comma-separated values (.csv)
    Tab-separated values (.tsv)
    Space-SV
    Semicolon-SV

    Delimiter-separated values
    or
    Character-SV

    View Slide




  29. Import Table format data
    object
    assignment operator
    file path
    function

    View Slide




  30. Import Table format data
    object
    assignment operator
    file path
    function

    View Slide

  31. ~/Documents/
    import.txt

    data





    or
    1. set working directory
    2. then use relative path
    Method②: use absolute path
    Method ①
    Import Table format data

    View Slide

  32. #
    #
    Method②: use absolute path
    Method ①: setwd – relative path
    "
    #
    or

    View Slide

  33. prj
    ~/Documents/R
    prj.Rproj
    import.txt
    Default working directory
    (project root)





    can use relative path
    without

    View Slide



  34. Import Table format data

    View Slide



  35. Import Table format data

    View Slide

  36. ) !
    (
    ) ! ! ( ) ∖
    # " !( !! ! (( # ! (( # ! ((
    # " ( ! # " ( ( ( () # ( ( ) (
    # () # ( ! ! (( ( # ( (
    # " ( !! ! # ! # ( (
    () ) ! # ! # ( (
    "" #) !! ( ( ! (
    () # ( ( ) ( !) () # ( ( ) (
    ! # # # # # # # ) ,)
    ( !
    Import Table format data

    View Slide

  37. ) !
    (
    ) ! ! ( ) ∖
    # " !( !! ! (( # ! (( # ! ((
    # " ( ! # " ( ( ( () # ( ( ) (
    # () # ( ! ! (( ( # ( (
    # " ( !! ! # ! # ( (
    () ) ! # ! # ( (
    "" #) !! ( ( ! (
    () # ( ( ) ( !) () # ( ( ) (
    ! # # # # # # # ) ,)
    ( !
    Import Table format data

    View Slide


  38. Usage
    read.table(file,
    skip = 0,
    header = FALSE,
    nrows = -1,
    row.names,
    fileEncoding = "")
    Import Table format data

    View Slide

  39. cf. R-Tips: 40.

    http://cse.naro.affrc.go.jp/takezawa/r-tips/r/40.html








    Import Table format data

    View Slide

  40. "
    " " "
    "
    cf. R-Tips: 40.

    http://cse.naro.affrc.go.jp/takezawa/r-tips/r/40.html
    Import Table format data

    View Slide

  41. "
    " " "
    "
    cf. R-Tips: 40.

    http://cse.naro.affrc.go.jp/takezawa/r-tips/r/40.html
    Import Table format data

    View Slide

  42. "
    " " "
    "
    cf. R-Tips: 40.

    http://cse.naro.affrc.go.jp/takezawa/r-tips/r/40.html
    Import Table format data

    View Slide

  43. "
    " " "
    "
    cf. R-Tips: 40.

    http://cse.naro.affrc.go.jp/takezawa/r-tips/r/40.html
    Import Table format data

    View Slide

  44. "
    " " "
    "
    cf. R-Tips: 40. # $

    http://cse.naro.affrc.go.jp/takezawa/r-tips/r/40.html
    Import Table format data
    # &_"# $
    # "
    # "/!
    # %"

    View Slide

  45. "
    " " "
    "
    cf. R-Tips: 40. # $

    http://cse.naro.affrc.go.jp/takezawa/r-tips/r/40.html
    Import Table format data
    # &_"# $
    # "
    # "/!
    # %"

    View Slide

  46. 67
    1 @y__mattu
    https://github.com/ymattu/TokyoR67
    Import Table format data

    View Slide






  47. Import Table format data
    Wrap

    View Slide



  48. Import Table format data

    Wrappers

    View Slide



  49. Import Table format data

    Wrappers

    View Slide

  50. Package

    {utils}
    Package
    {base}
    Package

    View Slide

  51. Package
    Package Package
    Package
    Package
    Package
    Package
    Package
    Package
    Package
    Package
    Package
    Package
    Package
    Package

    View Slide

  52. packages

    View Slide

  53. cf. http://rpkg.gepuro.net/
    cf. https://cran.r-project.org/web/packages/
    at 2018.02.20

    View Slide

  54. Package
    Default pkgs
    Package
    Package
    Package
    CRAN Guithub
    Package
    Package
    Package
    Package
    Package
    Package
    Package
    Package





    View Slide




  55. Import Table format data
    Default installed pkg
    (optional)
    Function


    Install REQUIRED

    View Slide

  56. Import Table format data
    List of installed packages

    View Slide

  57. Import Table format data




    Installation (from CRAN)



    Usage





    or

    View Slide

  58. Import Table format data
    Global environment
    # Attach {data.table}

    View Slide

  59. Import Table format data



    Fast!!!
    Flexible!!!
    Need installation
    Should specify: data.table =FALSE
    Automatic!!!
    Simple!!!

    View Slide








  60. object file path
    Export Table format data
    Wrapper

    View Slide

  61. Input
    Output
    Today’s talk
    ?
    ?
    Table data Image data Other formats Summary
    Introduction

    View Slide

  62. Image data
    Table data Image data Other formats Summary
    Introduction

    View Slide

  63. Export image data
    ?

    View Slide

  64. Export image data
    Use Graphic Device
    ready graphic device
    close graphic device
    draw graph(s)
    plotting functions
    High-level
    Low-level
    Interactive
    Basic Graphics in R
    http://bcb.dfci.harvard.edu/~aedin/courses/BiocDec2011/2.Plotting.pdf

    View Slide

  65. Export image data
    Use Graphic Device
    ready
    close
    draw





    High-level
    plotting function

    View Slide

  66. hogehoge
    ~/Documents/R
    hogehoge.Rproj
    hoge.png
    New!!

    View Slide

  67. Export image data
    Graphic Devices in

    View Slide

  68. Export image data
    Graphic Devices in
















    View Slide


  69. ready graphic device
    close graphic device
    draw graph(s)
    Image data processing
    Import & Export image



    processing

    View Slide


  70. Import image data




    View Slide


  71. Import image data




    View Slide


  72. Import image data










    View Slide


  73. Import image data










    View Slide

  74. Import image data






    Export image data


    # not CRAN pkg


    # low googlability
    !

    View Slide

  75. Import image data






    Export image data


    # not CRAN pkg


    # low googlability
    !

    View Slide

  76. View Slide

  77. View Slide

  78. View Slide

  79. Salvador Dalí
    1904-1989
    profile of time
    wikipedia

    View Slide

  80. http://seekr.jp/

    View Slide

  81. View Slide

  82. View Slide

  83. Input
    Output
    Today’s talk
    ?
    ?
    Table data Image data Other formats Summary
    Introduction

    View Slide

  84. Table data Image data Other formats
    Other formats
    Summary
    Introduction

    View Slide

  85. .xls or .xlsx


    GJMFQBUI
    TIFFUOBNFPS/P

    View Slide

  86. .json



    Wrap
    Wrap

    View Slide


  87. .wav or .mp3




    View Slide

  88. .sas or .dta or .sav
    SAS Stata SPSS









    View Slide


  89. Table data Image data Other formats Summary
    Introduction

    View Slide

  90. Input
    Output
    Do NOT start from here
    Whatever

    1
    2
    3

    View Slide

  91. Data Import / Export
    ?
    ?

    View Slide

  92. packages

    View Slide

  93. Data Import / Export
    ?
    ?











    packages

    View Slide

  94. ~/Documents/R
    project1
    project2
    project3
    project4

    View Slide

  95. Before After
    BeginneR Session

    ?

    View Slide

  96. !
    KMT©

    View Slide

  97. KMT©

    View Slide