Join Tables with {dplyr}

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024

Комментарии • 18

  • @WilOspinoC
    @WilOspinoC Год назад +1

    I freaking love this!!! Honestly old me used SQL scripts into R to avoid complexity, but now I can see dplyr makes it even simpleR. Thanks Yury. Greetings from Colombia

    • @yuzaR-Data-Science
      @yuzaR-Data-Science  Год назад +1

      Glad you liked it! Yeah, since I know dplyr, I stopped using SQL too

  • @abdulbouraa4529
    @abdulbouraa4529 Год назад

    Thank you so much !

  • @muhammedhadedy4570
    @muhammedhadedy4570 Год назад +1

    I love all your work, and I'm a big fan of your channel. Excellent tutorial as usual.
    Please, keep up the great work and thanks for everything.
    ❤❤❤❤❤

    • @yuzaR-Data-Science
      @yuzaR-Data-Science  Год назад +1

      Thank you very much, Muhammed! That means a lot to me! I will produce more content.

  • @chacmool2581
    @chacmool2581 4 месяца назад

    I too think that 'dplyr' walks all over SQL. When I've told databases SQL guys who don't know R, they look at me like I'm crazy. The only limitation is the memory limitation of R.

    • @yuzaR-Data-Science
      @yuzaR-Data-Science  4 месяца назад

      Exactly! I new SQL before R. But since I learned all I need for SQL in dplyr, I never touched SQL again ;)

    • @yuzaR-Data-Science
      @yuzaR-Data-Science  4 месяца назад

      yeah, the memory limitation is a problem, I got a new PC with tons of RAM and can't complain so far

  • @harryporter9965
    @harryporter9965 Год назад

    Hi Sir, (Out of context).
    How can I carry out a cross tabulation by setting some exclusion of values. For instance, variables under observation are x and y where x variable has zero values and should be excluded during plotting of the table.

    • @yuzaR-Data-Science
      @yuzaR-Data-Science  Год назад

      I don't think so, but i you need to exclude them anyway, why not just use dplyr to exclude them from x first, and then execute a join on x-table?

  • @richardbennett4365
    @richardbennett4365 9 месяцев назад

    Duckdb with Ibis.

    • @yuzaR-Data-Science
      @yuzaR-Data-Science  9 месяцев назад +1

      It’s similar, but it’s python, right?

    • @richardbennett4365
      @richardbennett4365 9 месяцев назад

      Yes.

    • @yuzaR-Data-Science
      @yuzaR-Data-Science  9 месяцев назад +1

      as I needed to use python, I found a couple of R similar packages our of laziness, but it worked well :)

    • @richardbennett4365
      @richardbennett4365 9 месяцев назад

      ​@@yuzaR-Data-Scienceby the way, I like your presentations. The animations and graphics are top-notch, clear, and easy to understand.

    • @richardbennett4365
      @richardbennett4365 9 месяцев назад

      ​@@yuzaR-Data-Scienceone more thing, I find Miniforge3 or micromamba, not Anaconda, to be the best way to manage python projects with their various packages and dependencies. Anaconda just installs way too much stuff.
      I'm also finding that LFortran can be installed as a kernel in Jupyter, so that's nice, too. And yes, one more thing, DataSpell can manage both R and python.