R ืฉืคึผืจืึทืš ืคึฟืึทืจ ืขืงืกืกืขืœ ื™ื•ื–ืขืจื– (ืคืจื™ื™ ื•ื•ื™ื“ืขื ืงื•ืจืก)

ืจืขื›ื˜ ืฆื• ืงืึทืจืึทื ื˜ื™ืŸ, ืคื™ืœืข ืื™ืฆื˜ ืคืึทืจื‘ืจืขื ื’ืขืŸ ื“ืขื ืœื™ื™ื‘ ืก ื˜ื™ื™ืœ ืคื•ืŸ ื–ื™ื™ืขืจ ืฆื™ื™ื˜ ืื™ืŸ ืฉื˜ื•ื‘, ืื•ืŸ ื“ื™ ืฆื™ื™ื˜ ืงืขื ืขืŸ, ืื•ืŸ ืืคื™ืœื• ื–ืึธืœ, ื–ื™ื™ืŸ ืคืืจื‘ืจืื›ื˜ ื ื•ืฆื™ืง.

ืื™ืŸ ื“ื™ ืึธื ื”ื™ื™ื‘ ืคื•ืŸ ืงืึทืจืึทื ื˜ื™ืŸ, ืื™ืš ื‘ืึทืฉืœืึธืกืŸ ืฆื• ืขื ื“ื™ืงืŸ ืขื˜ืœืขื›ืข ืคึผืจืึทื“ื–ืฉืขืงืก ื•ื•ืึธืก ืื™ืš ืกื˜ืึทืจื˜ืขื“ ืžื™ื˜ ืขื˜ืœืขื›ืข ื—ื“ืฉื™ื ืฆื•ืจื™ืง. ืื™ื™ื ืขืจ ืคื•ืŸ ื“ื™ ืคึผืจืึทื“ื–ืฉืขืงืก ืื™ื– ื’ืขื•ื•ืขืŸ ื“ื™ ื•ื•ื™ื“ืขื ืงื•ืจืก "ืจ ืฉืคึผืจืึทืš ืคึฟืึทืจ ืขืงืกืกืขืœ ื™ื•ื–ืขืจื–". ืžื™ื˜ ื“ืขื ืงื•ืจืก, ืื™ืš ื’ืขื•ื•ืืœื˜ ืฆื• ื ื™ื“ืขืจื™ืงืขืจ ื“ืขืจ ืฉืœืึทื‘ืึทืŸ ืฆื• ืคึผืึธื–ื™ืฆื™ืข ืื™ืŸ ืจ, ืื•ืŸ ืึท ื‘ื™ืกืœ ืคึผืœืึธืžื‘ื™ืจืŸ ื“ื™ ื™ื’ื–ื™ืกื˜ื™ื ื’ ื“ื•ื—ืง ืคื•ืŸ ื˜ืจื™ื™ื ื™ื ื’ ืžืึทื˜ืขืจื™ืึทืœืก ืื•ื™ืฃ ื“ืขื ื˜ืขืžืข ืื™ืŸ ืจื•ืกื™ืฉ.

ืื•ื™ื‘ ืึทืœืข ืึทืจื‘ืขื˜ ืžื™ื˜ ื“ืึทื˜ืŸ ืื™ืŸ ื“ื™ ืคื™ืจืžืข ืื™ืจ ืึทืจื‘ืขื˜ ืคึฟืึทืจ ืื™ื– ื ืึธืš ื’ืขื˜ืืŸ ืื™ืŸ ืขืงืกืกืขืœ, ืื™ืš ืคึฟืึธืจืฉืœืึธื’ืŸ ืื™ืจ ื‘ืึทืงื•ืžืขืŸ ื‘ืึทืงืึทื ื˜ ืžื™ื˜ ืึท ืžืขืจ ืžืึธื“ืขืจืŸ ืื•ืŸ ืื™ืŸ ื“ืขืจ ื–ืขืœื‘ื™ืงืขืจ ืฆื™ื™ื˜ ื’ืึธืจ ืคืจื™ื™ ื“ืึทื˜ืŸ ืึทื ืึทืœื™ืกื™ืก ื’ืขืฆื™ื™ึทื’.

R ืฉืคึผืจืึทืš ืคึฟืึทืจ ืขืงืกืกืขืœ ื™ื•ื–ืขืจื– (ืคืจื™ื™ ื•ื•ื™ื“ืขื ืงื•ืจืก)

ืฆื•ืคืจื™ื“ืŸ

ืื•ื™ื‘ ืื™ืจ ื–ืขื ื˜ ืื™ื ื˜ืขืจืขืกื™ืจื˜ ืื™ืŸ ื“ืึทื˜ืŸ ืึทื ืึทืœื™ืกื™ืก, ืื™ืจ ืงืขืŸ ื–ื™ื™ืŸ ืื™ื ื˜ืขืจืขืกื™ืจื˜ ืื™ืŸ ืžื™ื™ืŸ telegram ะธ ื™ืึธื•ื˜ื•ื‘ืข ื˜ืฉืึทื ืึทืœื–. ืจื•ื‘ึฟ ืคื•ืŸ ื“ื™ ืื™ื ื”ืึทืœื˜ ืื™ื– ื“ืขื“ืึทืงื™ื™ื˜ืึทื“ ืฆื• ื“ื™ R ืฉืคึผืจืึทืš.

  1. ืจืขืคึฟืขืจืขื ืฆืŸ
  2. ื•ื•ืขื’ืŸ ื“ืขื ืงื•ืจืก
  3. ืคึฟืึทืจ ื•ื•ืขืžืขืŸ ืื™ื– ื“ืขืจ ืงื•ืจืก?
  4. ืงื•ืจืก ืคึผืจืึธื’ืจืึทื
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 1: ื™ื ืกื˜ืึธืœื™ื ื’ ื“ื™ R ืฉืคึผืจืึทืš ืื•ืŸ ื“ื™ RStudio ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืกื•ื•ื™ื•ื•ืข
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 2: ื™ืงืขืจื“ื™ืง ื“ืึทื˜ืึท ืกื˜ืจืึทืงื˜ืฉืขืจื– ืื™ืŸ ืจ
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 3: ืœื™ื™ืขื ืขืŸ ื“ืึทื˜ืŸ ืคึฟื•ืŸ TSV, CSV, ืขืงืกืกืขืœ ื˜ืขืงืขืก ืื•ืŸ Google ืฉื™ืฅ
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 4: ืคื™ืœื˜ืขืจื™ื ื’ ืจืึธื•ื–, ืกืขืœืขืงื˜ื™ื ื’ ืื•ืŸ ืจื™ื ื™ื™ืžื™ื ื’ ืฉืคืืœื˜ืŸ, ืคึผื™ื™ืคึผืœื™ื™ื ื– ืื™ืŸ ืจ
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 5: ืึทื“ื™ื ื’ ืงืึทืœืงื™ืึทืœื™ื™ื˜ื™ื“ ืฉืคืืœื˜ืŸ ืฆื• ืึท ื˜ื™ืฉ ืื™ืŸ ืจ
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 6: ื’ืจื•ืคึผื™ื ื’ ืื•ืŸ ืึทื’ื’ืจืขื’ื™ื™ื˜ื™ื ื’ ื“ืึทื˜ืŸ ืื™ืŸ ืจ
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 7: ื•ื•ืขืจื˜ื™ืงืึทืœ ืื•ืŸ ื”ืึธืจื™ื–ืึธื ื˜ืึทืœ ืคืึทืจื‘ื™ื ื“ืŸ ืคื•ืŸ ื˜ื™ืฉืŸ ืื™ืŸ ืจ
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 8: ืคึฟืขื ืฆื˜ืขืจ ืคืึทื ื’ืงืฉืึทื ื– ืื™ืŸ ืจ
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 9: ืจืึธื•ื˜ื™ื™ื˜ื™ื ื’ ื˜ื™ืฉืŸ ืึธื“ืขืจ ืึทืŸ ืึทื ืึทืœืึธื’ ืคื•ืŸ ื“ืจื™ื™ืคึผื•ื ืงื˜ ื˜ื™ืฉืŸ ืื™ืŸ ืจ
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 10: ืœืึธื•ื“ื™ื ื’ JSON ื˜ืขืงืขืก ืื™ืŸ R ืื•ืŸ ืงืึทื ื•ื•ืขืจื˜ื™ื ื’ ืจืฉื™ืžื•ืช ืฆื• ื˜ื™ืฉืŸ
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 11: ืคึผืœืึทื˜ื™ื ื’ ื’ืขืฉื•ื•ื™ื ื“ ื ื™ืฆืŸ ื“ื™ qplot() ืคึฟื•ื ืงืฆื™ืข
    ืงืกื ื•ืžืงืก. ืœืขืงืฆื™ืข 12: ืคึผืœืึทื˜ื™ื ื’ ืฉื™ื›ื˜ืข ื“ื•ืจืš ืคึผืœืึทืฅ ืžื™ื˜ ื“ื™ ggplot2 ืคึผืขืงืœ
  5. ืกืึธืฃ

ืจืขืคึฟืขืจืขื ืฆืŸ

ื•ื•ืขื’ืŸ ื“ืขื ืงื•ืจืก

ื“ืขืจ ืงื•ืจืก ืื™ื– ืกื˜ืจืึทืงื˜ืฉืขืจื“ ืึทืจื•ื ืึทืจืงืึทื˜ืขืงื˜ืฉืขืจ tidyverse, ืื•ืŸ ื“ื™ ืคึผืึทืงืึทื“ื–ืฉืึทื– ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜ ืื™ืŸ ืขืก: readr, vroom, dplyr, tidyr, ggplot2. ืคื•ืŸ ืงื•ืจืก, ืขืก ื–ืขื ืขืŸ ืื ื“ืขืจืข ื’ื•ื˜ ืคึผืึทืงืึทื“ื–ืฉืึทื– ืื™ืŸ ืจ ื•ื•ืึธืก ื“ื•ืจื›ืคื™ืจืŸ ืขื ืœืขืš ืึทืคึผืขืจื™ื™ืฉืึทื ื–, ืคึฟืึทืจ ื‘ื™ื™ึทืฉืคึผื™ืœ data.table, ืึธื‘ืขืจ ื“ื™ ืกื™ื ื˜ืึทืงืก tidyverse ื™ื ื˜ื•ืึทื˜ื™ื•ื•, ื’ืจื™ื ื’ ืฆื• ืœื™ื™ืขื ืขืŸ ืืคื™ืœื• ืคึฟืึทืจ ืึทืŸ ืึทื ื˜ืจื™ื™ื™ื ื“ ื‘ืึทื ื™ืฆืขืจ, ืึทื–ื•ื™ ืื™ืš ื˜ืจืึทื›ื˜ืŸ ืขืก ืื™ื– ื‘ืขืกืขืจ ืฆื• ืึธื ื”ื™ื™ื‘ืŸ ืœืขืจื ืขืŸ ื“ื™ R ืฉืคึผืจืึทืš ืžื™ื˜ tidyverse.

ื“ืขืจ ืงื•ืจืก ื•ื•ืขื˜ ืคื™ืจืŸ ืื™ืจ ื“ื•ืจืš ืึทืœืข ื“ืึทื˜ืŸ ืึทื ืึทืœื™ืกื™ืก ืึทืคึผืขืจื™ื™ืฉืึทื ื–, ืคึฟื•ืŸ ืœืึธื•ื“ื™ื ื’ ืฆื• ื•ื•ื™ื–ืฉื•ื•ืึทืœื™ื™ื–ื™ื ื’ ื“ื™ ืคืึทืจื˜ื™ืง ืจืขื–ื•ืœื˜ืึทื˜.

ืคืืจื•ื•ืืก R ืื•ืŸ ื ื™ืฉื˜ Python? ื•ื•ื™ื™ึทืœ ืจ ืื™ื– ืึท ืคืึทื ื’ืงืฉืึทื ืึทืœ ืฉืคึผืจืึทืš, ืขืก ืื™ื– ื’ืจื™ื ื’ืขืจ ืคึฟืึทืจ ืขืงืกืกืขืœ ื ื™ืฆืขืจืก ืฆื• ื‘ืึทืฉื˜ื™ืžืขืŸ ืฆื• ืขืก, ื•ื•ื™ื™ึทืœ ื ื™ื˜ ื“ืึทืจืคึฟืŸ ืฆื• ื“ืขืœื•ื• ืื™ืŸ ื˜ืจืื“ื™ืฆื™ืื ืขืœืŸ ื›ื™ื™ืคืขืฅ-ืึธืจื™ืขื ื˜ื™ื“ ืคึผืจืึธื’ืจืึทืžืžื™ื ื’.

ื“ืขืจื•ื•ื™ื™ึทืœ, 12 ื•ื•ื™ื“ืขื ืœืขืงืฆื™ืขืก ื–ืขื ืขืŸ ืคึผืœืึทื ื ืขื“, ื•ื•ืึธืก ื’ืขื“ื•ื™ืขืจื˜ ืคื•ืŸ 5 ืฆื• 20 ืžื™ื ื•ื˜ ื™ืขื“ืขืจ.

ื“ื™ ืœืขืงืฆื™ืขืก ื•ื•ืขืœืŸ ื–ื™ืš ื‘ื™ืกืœืขื›ื•ื•ื™ื™ึทื– ืขืคืขื ืขืŸ. ื™ืขื“ืขืจ ืžืื ื˜ืื’ ืื™ืš ื•ื•ืขื˜ ืขืคืขื ืขืŸ ืึทืงืกืขืก ืฆื• ืึท ื ื™ื™ึทืข ืœืขืงืฆื™ืข ืื•ื™ืฃ ืžื™ื™ืŸ ื•ื•ืขื‘ื–ื™ื™ื˜ืœ. ื™ืึธื•ื˜ื•ื‘ืข ืงืึทื ืึทืœ ืื™ืŸ ืึท ื‘ืึทื–ื•ื ื“ืขืจ ืคึผืœื™ื™ึทืœื™ืกื˜.

ืคึฟืึทืจ ื•ื•ืขืžืขืŸ ืื™ื– ื“ืขืจ ืงื•ืจืก?

ืื™ืš ืžื™ื™ืŸ ืื– ื“ืืก ืื™ื– ืงืœืืจ ืคื•ื ืขื ื˜ื™ื˜ืœ, ืื‘ืขืจ ืื™ืš ื•ื•ืขืœ ืขืก ื‘ืืฉืจื™ื™ื‘ืŸ ืžืขืจ ื“ืขื˜ืึทืœ.

ื“ืขืจ ืงื•ืจืก ืื™ื– ืึทื™ืžืขื“ ืฆื• ื™ืขื ืข ื•ื•ืึธืก ืึทืงื˜ื™ื•ื•ืœื™ ื ื•ืฆืŸ Microsoft Excel ืื™ืŸ ื–ื™ื™ืขืจ ืึทืจื‘ืขื˜ ืื•ืŸ ื™ื ืกื˜ืจื•ืžืขื ื˜ ืึทืœืข ื–ื™ื™ืขืจ ืึทืจื‘ืขื˜ ืžื™ื˜ ื“ืึทื˜ืŸ ื“ืึธืจื˜. ืื™ืŸ ืึทืœื’ืขืžื™ื™ืŸ, ืื•ื™ื‘ ืื™ืจ ืขืคึฟืขื ืขืŸ ื“ื™ Microsoft Excel ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ ืื™ืŸ ืžื™ื ื“ืกื˜ืขืจ ืึทืžืึธืœ ืึท ื•ื•ืึธืš, ื“ืขืจ ืงื•ืจืก ืื™ื– ืคึผืึทืกื™ืง ืคึฟืึทืจ ืื™ืจ.

ืื™ืจ ื–ืขื ื˜ ื ื™ืฉื˜ ืคืืจืœืื ื’ื˜ ืฆื• ื”ืึธื‘ืŸ ืคึผืจืึธื’ืจืึทืžืžื™ื ื’ ืกืงื™ืœื– ืฆื• ืคืึทืจืขื ื“ื™ืงืŸ ื“ืขื ืงื•ืจืก, ื•ื•ื™ื™ึทืœ ... ื“ืขืจ ืงื•ืจืก ืื™ื– ืึทื™ืžืขื“ ืฆื• ื‘ื™ื’ื™ื ืขืจื–.

ืึธื‘ืขืจ, ื˜ืึธืžืขืจ, ืกื˜ืึทืจื˜ื™ื ื’ ืคื•ืŸ ืœืขืงืฆื™ืข 4, ืขืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ื˜ืฉื™ืงืึทื•ื•ืข ืžืึทื˜ืขืจื™ืึทืœ ืื•ื™ืš ืคึฟืึทืจ ืึทืงื˜ื™ื•ื• R ื ื™ืฆืขืจืก, ื•ื•ื™ื™ึทืœ ... ื“ื™ ื”ื•ื™ืคึผื˜ ืคืึทื ื’ืงืฉืึทื ืึทืœื™ื˜ื™ ืคื•ืŸ ืึทื–ืึท ืคึผืึทืงืึทื“ื–ืฉืึทื– ื•ื•ื™ dplyr ะธ tidyr ื•ื•ืขื˜ ื–ื™ื™ืŸ ื“ื™ืกืงืึทืกื˜ ืื™ืŸ ืขื˜ืœืขื›ืข ื“ืขื˜ืึทืœ.

ืงื•ืจืก ืคึผืจืึธื’ืจืึทื

ืœืขืงืฆื™ืข 1: ื™ื ืกื˜ืึธืœื™ื ื’ ื“ื™ R ืฉืคึผืจืึทืš ืื•ืŸ ื“ื™ RStudio ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืกื•ื•ื™ื•ื•ืข

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ืžืึทืจืฅ ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื•ื™ื“ืื•:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ืึท ื™ื ื˜ืจืึทื“ืึทืงื˜ืขืจื™ ืœืขืงืฆื™ืข ื‘ืขืฉืึทืก ื•ื•ืึธืก ืžื™ืจ ื•ื•ืขืœืŸ ืืจืืคืงืืคื™ืข ืื•ืŸ ื™ื ืกื˜ืึทืœื™ืจืŸ ื“ื™ ื ื™ื™ื˜ื™ืง ื•ื•ื™ื™ื›ื•ื•ืืจื’, ืื•ืŸ ื‘ืขืงื™ืฆืขืจ ื•ื ื˜ืขืจื–ื•ื›ืŸ ื“ื™ ืงื™ื™ืคึผืึทื‘ื™ืœืึทื˜ื™ื– ืื•ืŸ ืฆื•ื‘ื™ื ื“ ืคื•ืŸ ื“ื™ RStudio ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืกื•ื•ื™ื•ื•ืข.

ืœืขืงืฆื™ืข 2: ื™ืงืขืจื“ื™ืง ื“ืึทื˜ืึท ืกื˜ืจืึทืงื˜ืฉืขืจื– ืื™ืŸ ืจ

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ืžืึทืจืฅ ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื•ื™ื“ืื•:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ื“ืขืจ ืœืขืงืฆื™ืข ื•ื•ืขื˜ ื”ืขืœืคึฟืŸ ืื™ืจ ืคึฟืึทืจืฉื˜ื™ื™ืŸ ื•ื•ืึธืก ื“ืึทื˜ืŸ ืกื˜ืจืึทืงื˜ืฉืขืจื– ื–ืขื ืขืŸ ื‘ื ื™ืžืฆื ืื™ืŸ ื“ืขืจ ืฉืคึผืจืึทืš R. ืžื™ืจ ื•ื•ืขืœืŸ ืงื•ืงืŸ ืื™ืŸ ื“ืขื˜ืึทืœ ืื•ื™ืฃ ื•ื•ืขืงื˜ืึธืจืก, ื“ืึทื˜ืข ืจืึธืžืขืŸ ืื•ืŸ ืจืฉื™ืžื•ืช. ืœืึธืžื™ืจ ืœืขืจื ืขืŸ ื•ื•ื™ ืฆื• ืฉืึทืคึฟืŸ ื–ื™ื™ ืื•ืŸ ืึทืงืกืขืก ื–ื™ื™ืขืจ ื™ื—ื™ื“ ืขืœืขืžืขื ื˜ืŸ.

ืœืขืงืฆื™ืข 3: ืœื™ื™ืขื ืขืŸ ื“ืึทื˜ืŸ ืคึฟื•ืŸ TSV, CSV, ืขืงืกืกืขืœ ื˜ืขืงืขืก ืื•ืŸ Google ืฉื™ืฅ

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ืืคืจื™ืœ ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื•ื™ื“ืื•:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ืืจื‘ืขื˜ืŸ ืžื™ื˜ ื“ืึทื˜ืŸ, ืจืึทื’ืึทืจื“ืœืึทืก ืคื•ืŸ ื“ื™ ื’ืขืฆื™ื™ึทื’, ื”ื™ื™ื‘ื˜ ืžื™ื˜ ื–ื™ื™ึทืŸ ื™ืงืกื˜ืจืึทืงืฉืึทืŸ. ืคึผืึทืงืงืึทื’ืขืก ื–ืขื ืขืŸ ื’ืขื ื™ืฆื˜ ื‘ืขืฉืึทืก ื“ื™ ืœืขืงืฆื™ืข vroom, readxl, googlesheets4 ืคึฟืึทืจ ืœืึธื•ื“ื™ื ื’ ื“ืึทื˜ืŸ ืื™ืŸ ื“ื™ R ืกื•ื•ื™ื•ื•ืข ืคึฟื•ืŸ ืงืกื•ื•, ืฆื•ื•, ืขืงืกืกืขืœ ื˜ืขืงืขืก ืื•ืŸ Google ืฉื™ืฅ.

ืœืขืงืฆื™ืข 4: ืคื™ืœื˜ืขืจื™ื ื’ ืจืึธื•ื–, ืกืขืœืขืงื˜ื™ื ื’ ืื•ืŸ ืจื™ื ื™ื™ืžื™ื ื’ ืฉืคืืœื˜ืŸ, ืคึผื™ื™ืคึผืœื™ื™ื ื– ืื™ืŸ ืจ

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ืืคืจื™ืœ ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื•ื™ื“ืื•:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ื“ืขืจ ืœืขืงืฆื™ืข ืื™ื– ื•ื•ืขื’ืŸ ื“ืขื ืคึผืขืงืœ dplyr. ืื™ืŸ ืขืก ืžื™ืจ ื•ื•ืขืœืŸ ืจืขื›ืขื ืขืŸ ืื•ื™ืก ื•ื•ื™ ืฆื• ืคื™ืœื˜ืขืจ ื“ืึทื˜ืึทืคืจืึทืžืขืก, ืกืขืœืขืงื˜ื™ืจืŸ ื“ื™ ื ื™ื™ื˜ื™ืง ืฉืคืืœื˜ืŸ ืื•ืŸ ืจืขื ืึทืžืข ื–ื™ื™.

ืžื™ืจ ื•ื•ืขืœืŸ ืื•ื™ืš ืœืขืจื ืขืŸ ื•ื•ืึธืก ืคึผื™ื™ืคึผืœื™ื™ื ื– ื–ืขื ืขืŸ ืื•ืŸ ื•ื•ื™ ื–ื™ื™ ื”ืขืœืคึฟืŸ ืžืึทื›ืŸ ื“ื™ื™ืŸ R ืงืึธื“ ืžืขืจ ืœื™ื™ื ืขื•ื•ื“ื™ืง.

ืœืขืงืฆื™ืข 5: ืึทื“ื™ื ื’ ืงืึทืœืงื™ืึทืœื™ื™ื˜ื™ื“ ืฉืคืืœื˜ืŸ ืฆื• ืึท ื˜ื™ืฉ ืื™ืŸ ืจ

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ืืคืจื™ืœ ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื•ื™ื“ืื•:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ืื™ืŸ ื“ืขื ื•ื•ื™ื“ืขื ืžื™ืจ ืคืึธืจื–ืขืฆืŸ ืื•ื ื“ื–ืขืจ ื‘ืึทืงืึทื ื˜ืขืจ ืžื™ื˜ ื“ืขืจ ื‘ื™ื‘ืœื™ืึธื˜ืขืง tidyverse ืื•ืŸ ืคึผืขืงืœ dplyr.
ื–ืืœ ืก ืงื•ืง ืื™ืŸ ื“ื™ ืžืฉืคึผื—ื” ืคื•ืŸ ืคืึทื ื’ืงืฉืึทื ื– mutate(), ืื•ืŸ ืžื™ืจ ื•ื•ืขืœืŸ ืœืขืจื ืขืŸ ื•ื•ื™ ืฆื• ื ื•ืฆืŸ ื–ื™ื™ ืฆื• ืœื™ื™ื’ืŸ ื ื™ื™ึท ืงืึทืœืงื™ืึทืœื™ื™ื˜ื™ื“ ืฉืคืืœื˜ืŸ ืฆื• ื“ื™ ื˜ื™ืฉ.

ืœืขืงืฆื™ืข 6: ื’ืจื•ืคึผื™ื ื’ ืื•ืŸ ืึทื’ื’ืจืขื’ื™ื™ื˜ื™ื ื’ ื“ืึทื˜ืŸ ืื™ืŸ ืจ

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ืืคืจื™ืœ ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื•ื™ื“ืื•:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ื“ืขืจ ืœืขืงืฆื™ืข ืื™ื– ื“ืขื“ืึทืงื™ื™ื˜ืึทื“ ืฆื• ืื™ื™ื ืขืจ ืคื•ืŸ ื“ื™ ื”ื•ื™ืคึผื˜ ืึทืคึผืขืจื™ื™ืฉืึทื ื– ืคื•ืŸ ื“ืึทื˜ืŸ ืึทื ืึทืœื™ืกื™ืก, ื’ืจื•ืคึผื™ื ื’ ืื•ืŸ ืึทื’ื’ืจืขื’ืึทื˜ื™ืึธืŸ. ื‘ืขืฉืึทืก ื“ื™ ืœืขืงืฆื™ืข ืžื™ืจ ื•ื•ืขืœืŸ ื ื•ืฆืŸ ื“ืขื ืคึผืขืงืœ dplyr ืื•ืŸ ืคึฟืขื™ึดืงื™ื™ื˜ืŸ group_by() ะธ summarise().

ืžื™ืจ ื•ื•ืขืœืŸ ืงื•ืงืŸ ืื™ืŸ ื“ื™ ื’ืื ืฆืข ืžืฉืคึผื—ื” ืคื•ืŸ ืคืึทื ื’ืงืฉืึทื ื– summarise(), ื™.ืข. summarise(), summarise_if() ะธ summarise_at().

ืœืขืงืฆื™ืข 7: ื•ื•ืขืจื˜ื™ืงืึทืœ ืื•ืŸ ื”ืึธืจื™ื–ืึธื ื˜ืึทืœ ืคืึทืจื‘ื™ื ื“ืŸ ืคื•ืŸ ื˜ื™ืฉืŸ ืื™ืŸ ืจ

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ืžื™ื™ึท ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื•ื™ื“ืื•:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ื“ืขืจ ืœืขืงืฆื™ืข ื•ื•ืขื˜ ื”ืขืœืคึฟืŸ ืื™ืจ ืคึฟืึทืจืฉื˜ื™ื™ืŸ ื“ื™ ืึทืคึผืขืจื™ื™ืฉืึทื ื– ืคื•ืŸ ื•ื•ืขืจื˜ื™ืงืึทืœ ืื•ืŸ ื”ืึธืจื™ื–ืึธื ื˜ืึทืœ ื“ื–ืฉื•ื™ื ื™ื ื’ ื˜ื™ืฉืŸ.

ื ื•ื•ืขืจื˜ื™ืงืึทืœ ืคืึทืจื‘ืึทื ื“ ืื™ื– ื“ืขืจ ืขืงื•ื•ื™ื•ื•ืึทืœืขื ื˜ ืคื•ืŸ ื“ื™ UNION ืึธืคึผืขืจืึทืฆื™ืข ืื™ืŸ ื“ื™ SQL ืึธื ืคึฟืจืขื’ ืฉืคึผืจืึทืš.

ื”ืึธืจื™ื–ืึธื ื˜ืึทืœ ืคืึทืจื‘ื™ื ื“ืŸ ืื™ื– ื‘ืขืกืขืจ ื‘ืืงืื ื˜ ืคึฟืึทืจ ืขืงืกืกืขืœ ื™ื•ื–ืขืจื– ื“ืึทื ืง ืฆื• ื“ื™ VLOOKUP ืคื•ื ืงืฆื™ืข; ืื™ืŸ SQL, ืึทื–ืึท ืึทืคึผืขืจื™ื™ืฉืึทื ื– ื–ืขื ืขืŸ ื“ื•ืจื›ื’ืขืงืึธื›ื˜ ื“ื•ืจืš ื“ื™ JOIN ืึธืคึผืขืจืึทื˜ืึธืจ.

ื‘ืขืฉืึทืก ื“ื™ ืœืขืงืฆื™ืข ืžื™ืจ ื•ื•ืขืœืŸ ืกืึธืœื•ื•ืข ืึท ืคึผืจืึทืงื˜ื™ืฉ ืคึผืจืึธื‘ืœืขื ื‘ืขืฉืึทืก ื•ื•ืึธืก ืžื™ืจ ื•ื•ืขืœืŸ ื ื•ืฆืŸ ืคึผืึทืงืึทื“ื–ืฉืึทื– dplyr, readxl, tidyr ะธ stringr.

ื“ื™ ื”ื•ื™ืคึผื˜ ืคืึทื ื’ืงืฉืึทื ื– ื•ื•ืึธืก ืžื™ืจ ื•ื•ืขืœืŸ ื‘ืึทื˜ืจืึทื›ื˜ืŸ:

  • bind_rows() - ื•ื•ืขืจื˜ื™ืงืึทืœ ืคืึทืจื‘ื™ื ื“ืŸ ืคื•ืŸ ื˜ื™ืฉืŸ
  • left_join() - ื”ืึธืจื™ื–ืึธื ื˜ืึทืœ ืคืึทืจื‘ื™ื ื“ืŸ ืคื•ืŸ ื˜ื™ืฉืŸ
  • semi_join() - ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜ ื“ื–ืฉื•ื™ื ื™ื ื’ ื˜ื™ืฉืŸ
  • anti_join() - ื•ื™ืกืฉืœื™ืกื™ืง ื˜ื™ืฉ ืคืึทืจื‘ื™ื ื“ืŸ

ืœืขืงืฆื™ืข 8: ืคึฟืขื ืฆื˜ืขืจ ืคืึทื ื’ืงืฉืึทื ื– ืื™ืŸ ืจ

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ืžื™ื™ึท ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ืคึฟืขื ืฆื˜ืขืจ ืคืึทื ื’ืงืฉืึทื ื– ื–ืขื ืขืŸ ืขื ืœืขืš ืื™ืŸ ื˜ื™ื™ึทื˜ืฉ ืฆื• ืึทื’ื’ืจืขื’ื™ื™ื˜ื™ื ื’ ืึธื ืขืก; ื–ื™ื™ ืื•ื™ืš ื ืขืžืขืŸ ืึท ืžืขื ื’ืข ืคื•ืŸ โ€‹โ€‹ื•ื•ืึทืœื•ืขืก ื•ื•ื™ ืึทืจื™ื™ึทื ืฉืจื™ื™ึทื‘ ืื•ืŸ ื“ื•ืจื›ืคื™ืจืŸ ืึทืจื™ื˜ืžืขื˜ื™ืง ืึทืคึผืขืจื™ื™ืฉืึทื ื– ืื•ื™ืฃ ื–ื™ื™, ืึธื‘ืขืจ ื˜ืึธืŸ ื ื™ื˜ ื˜ื•ื™ืฉืŸ ื“ื™ ื ื•ืžืขืจ ืคื•ืŸ ืจืึธื•ื– ืื™ืŸ ื“ื™ ืจืขื–ื•ืœื˜ืึทื˜ ืจืขื–ื•ืœื˜ืึทื˜.

ืื™ืŸ ื“ืขื ื˜ื•ื˜ืึธืจื™ืึทืœ ืžื™ืจ ืคืึธืจื–ืขืฆืŸ ืฆื• ืœืขืจื ืขืŸ ื“ืขื ืคึผืขืงืœ dplyr, ืื•ืŸ ืคืึทื ื’ืงืฉืึทื ื– group_by(), mutate(), ื•ื•ื™ ื’ืขื–ื•ื ื˜ ื•ื•ื™ ื ื™ื™ึท cumsum(), lag(), lead() ะธ arrange().

ืœืขืงืฆื™ืข 9: ืจืึธื•ื˜ื™ื™ื˜ื™ื ื’ ื˜ื™ืฉืŸ ืึธื“ืขืจ ืึทืŸ ืึทื ืึทืœืึธื’ ืคื•ืŸ ื“ืจื™ื™ืคึผื•ื ืงื˜ ื˜ื™ืฉืŸ ืื™ืŸ ืจ

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ืžื™ื™ึท ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ืจื•ื‘ึฟ ืขืงืกืกืขืœ ื™ื•ื–ืขืจื– ื ื•ืฆืŸ ื“ืจื™ื™ืคึผื•ื ืงื˜ ื˜ื™ืฉืŸ; ื“ืึธืก ืื™ื– ืึท ื‘ืึทืงื•ื•ืขื ื’ืขืฆื™ื™ึทื’ ืžื™ื˜ ื•ื•ืึธืก ืื™ืจ ืงืขื ืขืŸ ื•ื•ืขื ื“ืŸ ืึท ืžืขื ื’ืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ืจื•ื™ ื“ืึทื˜ืŸ ืื™ืŸ ืœื™ื™ื ืขื•ื•ื“ื™ืง ืจื™ืคึผืึธืจืฅ ืื™ืŸ ืึท ืขื ื™ืŸ ืคื•ืŸ ืกืขืงื•ื ื“ืขืก.

ืื™ืŸ ื“ืขื ื˜ื•ื˜ืึธืจื™ืึทืœ ืžื™ืจ ื•ื•ืขืœืŸ ืงื•ืงืŸ ืื™ืŸ ื•ื•ื™ ืฆื• ื“ืจื™ื™ืขืŸ ื˜ื™ืฉืŸ ืื™ืŸ ืจ, ืื•ืŸ ื’ืขืจ ื–ื™ื™ ืคื•ืŸ ื‘ืจื™ื™ื˜ ืฆื• ืœืึทื ื’ ืคึฟืึธืจืžืึทื˜ ืื•ืŸ ื•ื•ื™ืฆืข ื•ื•ืขืจืกืึท.

ืจื•ื‘ึฟ ืคื•ืŸ ื“ื™ ืœืขืงืฆื™ืข ืื™ื– ื“ืขื“ืึทืงื™ื™ื˜ืึทื“ ืฆื• ื“ืขื ืคึผืขืงืœ tidyr ืื•ืŸ ืคืึทื ื’ืงืฉืึทื ื– pivot_longer() ะธ pivot_wider().

ืœืขืงืฆื™ืข 10: ืœืึธื•ื“ื™ื ื’ JSON ื˜ืขืงืขืก ืื™ืŸ R ืื•ืŸ ืงืึทื ื•ื•ืขืจื˜ื™ื ื’ ืจืฉื™ืžื•ืช ืฆื• ื˜ื™ืฉืŸ

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ืžื™ื™ึท ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
JSON ืื•ืŸ XML ื–ืขื ืขืŸ ื’ืึธืจ ืคืึธืœืงืก ืคึฟืึธืจืžืึทื˜ื™ืจื•ื ื’ืขืŸ ืคึฟืึทืจ ืกื˜ืึธืจื™ื ื’ ืื•ืŸ ื™ืงืกื˜ืฉื™ื™ื ื“ื–ืฉื™ื ื’ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข, ื™ื•ื–ืฉืึทื•ื•ืึทืœื™ ืจืขื›ื˜ ืฆื• ื–ื™ื™ืขืจ ืงืึทืžืคึผืึทืงื˜ื ืึทืก.

ืึธื‘ืขืจ ืขืก ืื™ื– ืฉื•ื•ืขืจ ืฆื• ืคื•ื ืึทื ื“ืขืจืงืœื™ื™ึทื‘ืŸ ื“ืึทื˜ืŸ ื“ืขืจืœืื ื’ื˜ ืื™ืŸ ืึทื–ืึท ืคึฟืึธืจืžืึทื˜ื™ืจื•ื ื’ืขืŸ, ืึทื–ื•ื™ ืื™ื™ื“ืขืจ ืึทื ืึทืœื™ืกื™ืก ืขืก ืื™ื– ื ื™ื™ื˜ื™ืง ืฆื• ื‘ืจืขื ื’ืขืŸ ืขืก ืื™ืŸ ืึท ื˜ืึทื‘ื•ืœืึทืจ ืคืึธืจืขื, ื•ื•ืึธืก ืื™ื– ืคึผื•ื ืงื˜ ื•ื•ืึธืก ืžื™ืจ ื•ื•ืขืœืŸ ืœืขืจื ืขืŸ ืื™ืŸ ื“ืขื ื•ื•ื™ื“ืขื.

ื“ื™ ืœืขืงืฆื™ืข ืื™ื– ื“ืขื“ืึทืงื™ื™ื˜ืึทื“ ืฆื• ื“ืขื ืคึผืขืงืœ tidyr, ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜ ืื™ืŸ ื“ื™ ื”ืึทืจืฅ ืคื•ืŸ ื“ืขืจ ื‘ื™ื‘ืœื™ืึธื˜ืขืง tidyverse, ืื•ืŸ ืคืึทื ื’ืงืฉืึทื ื– unnest_longer(), unnest_wider() ะธ hoist().

ืœืขืงืฆื™ืข 11: ืคึผืœืึทื˜ื™ื ื’ ื’ืขืฉื•ื•ื™ื ื“ ื ื™ืฆืŸ ื“ื™ qplot() ืคึฟื•ื ืงืฆื™ืข

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ื™ื•ื ื™ ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ืคึผืขืงืœ ggplot2 ืื™ื– ืื™ื™ื ืขืจ ืคื•ืŸ ื“ื™ ืžืขืจืกื˜ ืคืึธืœืงืก ื“ืึทื˜ืŸ ื•ื•ื™ื–ืฉื•ื•ืึทืœืึทื–ื™ื™ืฉืึทืŸ ืžื›ืฉื™ืจื™ื ื ื™ื˜ ื‘ืœื•ื™ื– ืื™ืŸ R.

ืื™ืŸ ื“ืขื ืœืขืงืฆื™ืข ืžื™ืจ ื•ื•ืขืœืŸ ืœืขืจื ืขืŸ ื•ื•ื™ ืฆื• ื‘ื•ื™ืขืŸ ืคึผืฉื•ื˜ ื’ืจืึทืคืก ืžื™ื˜ ื“ื™ ืคึฟื•ื ืงืฆื™ืข qplot(), ืื•ืŸ ืœืึธืžื™ืจ ืึทื ืึทืœื™ื™ื– ืึทืœืข ืื™ืจืข ื˜ืขื ื•ืช.

ืœืขืงืฆื™ืข 12: ืคึผืœืึทื˜ื™ื ื’ ืฉื™ื›ื˜ืข ื“ื•ืจืš ืคึผืœืึทืฅ ืžื™ื˜ ื“ื™ ggplot2 ืคึผืขืงืœ

ื“ืื˜ื•ื ืคื•ืŸ ืืจื•ื™ืกื’ืขื‘ืŸ: ื™ื•ื ื™ ืงืกื ื•ืžืงืก ืงืกื ื•ืžืงืก

ืœื™ื ืงืก:

ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’:
ื“ืขืจ ืœืขืงืฆื™ืข ื“ืขืžืึทื ืกื˜ืจื™ื™ืฅ ื“ื™ ืคื•ืœ ืžืึทื›ื˜ ืคื•ืŸ ื“ืขื ืคึผืขืงืœ ggplot2 ืื•ืŸ ื“ื™ ื’ืจืึทืžืึทื˜ื™ืง ืคื•ืŸ ื‘ื ื™ืŸ ื’ืจืึทืคืก ืื™ืŸ ืฉื™ื›ื˜ืŸ ืขืžื‘ืขื“ื™ื“ ืื™ืŸ ืขืก.

ืžื™ืจ ื•ื•ืขืœืŸ ืึทื ืึทืœื™ื™ื– ื“ื™ ื”ื•ื™ืคึผื˜ ื’ืขืึธืžืขื˜ืจื™ืขืก ื•ื•ืึธืก ื–ืขื ืขืŸ ืคืึธืจืฉื˜ืขืœืŸ ืื™ืŸ ื“ืขื ืคึผืขืงืœ ืื•ืŸ ืœืขืจื ืขืŸ ื•ื•ื™ ืฆื• ืฆื•ืœื™ื™ื’ืŸ ืœื™ื™ึทืขืจืก ืฆื• ื‘ื•ื™ืขืŸ ืึท ื’ืจืึทืคื™ืง.

ืกืึธืฃ

ืื™ืš ื”ืึธื‘ ื’ืขืคึผืจื•ืื•ื•ื˜ ืฆื•ื’ืึทื ื’ ื“ื™ ืคืึธืจืžื™ืจื•ื ื’ ืคื•ืŸ ื“ื™ ืงื•ืจืก ืคึผืจืึธื’ืจืึทื ื•ื•ื™ ืงืึทื ืกื™ื™ืกืœื™ ื•ื•ื™ ืžืขื’ืœืขืš, ืฆื• ื”ื•ื™ื›ืคึผื•ื ืงื˜ ื‘ืœื•ื™ื– ื“ื™ ืžืขืจืกื˜ ื ื™ื™ื˜ื™ืง ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ื•ื•ืึธืก ืื™ืจ ื•ื•ืขื˜ ื“ืึทืจืคึฟืŸ ืฆื• ื ืขืžืขืŸ ื“ื™ ืขืจืฉื˜ืขืจ ืกื˜ืขืคึผืก ืื™ืŸ ืœืขืจื ืขืŸ ืึทื–ืึท ืึท ืฉื˜ืึทืจืง ื“ืึทื˜ืŸ ืึทื ืึทืœื™ืกื™ืก ื’ืขืฆื™ื™ึทื’ ื•ื•ื™ ื“ื™ R ืฉืคึผืจืึทืš.

ื“ืขืจ ืงื•ืจืก ืื™ื– ื ื™ืฉื˜ ืึท ื™ื’ื–ืึธืกื˜ื™ื•ื• ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ ืคึฟืึทืจ ื“ืึทื˜ืŸ ืึทื ืึทืœื™ืกื™ืก ืžื™ื˜ ื“ื™ R ืฉืคึผืจืึทืš, ืึธื‘ืขืจ ืขืก ื•ื•ืขื˜ ื”ืขืœืคึฟืŸ ืื™ืจ ืคึฟืึทืจืฉื˜ื™ื™ืŸ ืึทืœืข ื“ื™ ื ื™ื™ื˜ื™ืง ื˜ืขืงื ื™ืงืก ืคึฟืึทืจ ื“ืขื.

ื›ืึธื˜ืฉ ื“ื™ ืงื•ืจืก ืคึผืจืึธื’ืจืึทื ืื™ื– ื“ื™ื–ื™ื™ื ื“ ืคึฟืึทืจ 12 ื•ื•ืึธื›ืŸ, ื™ืขื“ืขืจ ื•ื•ืึธืš ืื•ื™ืฃ ืžืึธื ื“ื™ื™ึทืก ืื™ืš ื•ื•ืขื˜ ืขืคืขื ืขืŸ ืึทืงืกืขืก ืฆื• ื ื™ื™ึทืข ืœืขืงืฆื™ืขืก, ืึทื–ื•ื™ ืื™ืš ืจืขืงืึธืžืขื ื“ื™ืจืŸ ืึทื‘ืึธื ื™ืจืŸ ืื•ื™ืฃ ื“ื™ ื™ืึธื•ื˜ื•ื‘ืข ืงืึทื ืึทืœ ืึทื–ื•ื™ ื•ื•ื™ ื ื™ืฉื˜ ืฆื• ืคืึทืจืคื™ืจืŸ ื“ื™ ื•ื™ืกื’ืึทื‘ืข ืคื•ืŸ โ€‹โ€‹ืึท ื ื™ื™ึทืข ืœืขืงืฆื™ืข.

ืžืงื•ืจ: www.habr.com

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’