Excel to R - Marketing Analytics Case Study in R | Learning Lab

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

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

  • @alexpenatosta
    @alexpenatosta 2 года назад +2

    Excellent material, thanks a lot for sharing!

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

    Excellent video! How can we download the data set?

    • @BusinessScience
      @BusinessScience  7 месяцев назад

      It’s a learning lab. Everything is included here: university.business-science.io/p/learning-labs-pro?el=website

  • @miguelsoriatalavera5778
    @miguelsoriatalavera5778 4 года назад +2

    Interesting research. Thanks 4 all

  • @Amanuail1
    @Amanuail1 2 года назад +1

    Thanks for the video! Can you tell me the name of the company that this case study are taken place from?

    • @BusinessScience
      @BusinessScience  2 года назад

      The company is fictional. It’s a demo based on real world.

  • @dogfish123
    @dogfish123 2 года назад +1

    Hi Matt,
    Thanks for the great tutorial.
    I hope you can help with my query.
    I am stuck with the step_dummy function.
    The script is running fine for me (see below) up until this point but it does not convert the categorical data into binary.
    I still only have 17 columns with 45k rows after running this.
    I have checked that my libraries are all the required versions and seem to have no issue there.
    Do you have any suggestions?
    Thanks Matt, John.
    recipe_obj %
    step_rm(ID) %>%
    step_discretize(all_numeric(), options = list(min_unique = 1)) %>%
    step_dummy(all_nominal(), one_hot = TRUE, naming = partial(dummy_names, sep = "__")) %>%
    prep()

    • @uchekalu7725
      @uchekalu7725 2 года назад

      Same issue here. PDAYS variable values is being collated into just one bin with one level. How'd you resolve this please?

    • @erickrangel6024
      @erickrangel6024 11 месяцев назад

      Same problem

    • @niweditaburnwal8307
      @niweditaburnwal8307 10 месяцев назад

      Hi...have you got solution to this? I am also stuck here

  • @123admini2r
    @123admini2r 4 года назад +1

    we could tableau too right

  • @123admini2r
    @123admini2r 4 года назад +1

    37:18 good man

  • @1622roma
    @1622roma Год назад

    Could you guys do something about the video's blurriness? After running each line of code, this error message comes up? Can you explain this error message?
    > # 3.0 PERFORM VLOOKUP EQUIVALENT ----
    Error in exists(cacheKey, where = .rs.WorkingDataEnv, inherits = FALSE) :
    invalid first argument
    > data_joined_tbl %
    Error in exists(cacheKey, where = .rs.WorkingDataEnv, inherits = FALSE) :
    invalid first argument
    + map(~ read_excel(path = path, sheet = .)) %>%
    Error in exists(cacheKey, where = .rs.WorkingDataEnv, inherits = FALSE) :
    invalid first argument
    + reduce(left_join)
    Error in exists(cacheKey, where = .rs.WorkingDataEnv, inherits = FALSE) :
    invalid first argument

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

      Try changing your quality from auto to a higher setting. RUclips defaults to lower resolution.

  • @midwest042003
    @midwest042003 5 лет назад

    Hello all,
    Thanks a lot for this tutorial. Please I have a question.
    I tried:
    map(sheets~ read_excel(path = path, sheet = .))
    But got an error> Why is this so? I imagine thw "%>%"(pipe) just supplies the data to the nested function. How come it gives an error when applied directly?

    • @BusinessScience
      @BusinessScience  5 лет назад

      Hi Onimisi, Please double-check the verified code against your code. You can see it here: github.com/business-science/presentations/blob/master/2019_02_13_Learning_Lab_Marketing_Analytics/marketing_analysis.R

  • @DataFunAnalyticaltricks
    @DataFunAnalyticaltricks 4 года назад +1

    Great job

  • @calstateeastbayanalyticscl5731
    @calstateeastbayanalyticscl5731 5 лет назад

    Hello,
    27:10 code is not running. It gives me an error "Could not find function %>%"

    • @BusinessScience
      @BusinessScience  5 лет назад +1

      Make sure you load the tidyverse library - library(tidyverse) You will need to install all of the packages with install.packages("package_name")

  • @janiobachmann5029
    @janiobachmann5029 5 лет назад

    Hello,
    I am getting the following error for the one_hot=TRUE parameter in step_dummies:
    `TRUE` must evaluate to column positions or names, not a logical vector .

    • @BusinessScience
      @BusinessScience  5 лет назад

      Did you check against the verified code? github.com/business-science/presentations/blob/master/2019_02_13_Learning_Lab_Marketing_Analytics/marketing_analysis.R

    • @janiobachmann5029
      @janiobachmann5029 5 лет назад

      Hey Matt, Yeah I copied and paste the code and it gives me that error. I don't know if someone else has had this error. However, if I just use the code like this,
      recipe_obj %
      step_rm(ID) %>%
      step_discretize(all_numeric(), options = list(min_unique = 1)) %>%
      step_dummy(all_nominal())%>%
      prep()
      It works, the only thing I have less variables as you do because it is not using the one-hot encoding parameter. I'll try and find what possible error it could be.

    • @janiobachmann5029
      @janiobachmann5029 5 лет назад +1

      Great course Matt, Can't wait to start taking this course. I find R to be a really good platform especially for business analysis. Thanks for providing this video.

    • @BusinessScience
      @BusinessScience  5 лет назад

      @@janiobachmann5029 Awesome!! The courses are great. You will be amazed where you go with it. This is just one example of what you can do. And, for business analysis, R will change your life.

    • @BusinessScience
      @BusinessScience  5 лет назад

      We have a good Learning Lab coming up - H2O unleashed - zoom.us/webinar/register/WN_IuKxXfp6TVeixKAPRrr0-Q

  • @samikshasingh8325
    @samikshasingh8325 2 года назад

    There is nothing...