Convert Multiple Column Classes










5















I think this is a simple question but I haven't found a suitable solution. To begin with a set of simplified data :



df <- as.data.frame(matrix(1:20, 5, 4))
str(df)

# 'data.frame': 5 obs. of 4 variables:
# $ V1: int 1 2 3 4 5
# $ V2: int 6 7 8 9 10
# $ V3: int 11 12 13 14 15
# $ V4: int 16 17 18 19 20


We can see that all the classes are the integer. What I wanna achieve is converting the 4 classes to integer, numeric, character, and factor respectively. Of course, I can use



df$V1 <- as.XXX(df$V1)


for each column, but I think it's inefficient.



Expected Output



# 'data.frame': 5 obs. of 4 variables:
# $ V1: int 1 2 3 4 5
# $ V2: num 6 7 8 9 10
# $ V3: chr "11" "12" "13" "14" ...
# $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5



Question 2



I reference @joran's answer in R Assign (or copy) column classes from a data frame to another and run the following code :



myclass <- c("integer", "numeric", "character", "factor")
df.2 <- df
df.2 <- mapply(FUN = as, df.2, myclass, SIMPLIFY = F)


When I call df.2, an error appears :




Error in as.character.factor(x) : malformed factor




However, It's okay to call str(df.2), and apparently only V1 and V3 reach my request.



str(df.2)

# 'data.frame': 5 obs. of 4 variables:
# $ V1: int 1 2 3 4 5
# $ V2: int 6 7 8 9 10
# $ V3: chr "11" "12" "13" "14" ...
# $ V4:Formal class 'factor' [package "methods"] with 3 slots
# .. ..@ .Data : int 16 17 18 19 20
# .. ..@ levels : chr
# .. ..@ .S3Class: chr "factor"


Why cannot as function deal with classes numeric and factor?










share|improve this question




























    5















    I think this is a simple question but I haven't found a suitable solution. To begin with a set of simplified data :



    df <- as.data.frame(matrix(1:20, 5, 4))
    str(df)

    # 'data.frame': 5 obs. of 4 variables:
    # $ V1: int 1 2 3 4 5
    # $ V2: int 6 7 8 9 10
    # $ V3: int 11 12 13 14 15
    # $ V4: int 16 17 18 19 20


    We can see that all the classes are the integer. What I wanna achieve is converting the 4 classes to integer, numeric, character, and factor respectively. Of course, I can use



    df$V1 <- as.XXX(df$V1)


    for each column, but I think it's inefficient.



    Expected Output



    # 'data.frame': 5 obs. of 4 variables:
    # $ V1: int 1 2 3 4 5
    # $ V2: num 6 7 8 9 10
    # $ V3: chr "11" "12" "13" "14" ...
    # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5



    Question 2



    I reference @joran's answer in R Assign (or copy) column classes from a data frame to another and run the following code :



    myclass <- c("integer", "numeric", "character", "factor")
    df.2 <- df
    df.2 <- mapply(FUN = as, df.2, myclass, SIMPLIFY = F)


    When I call df.2, an error appears :




    Error in as.character.factor(x) : malformed factor




    However, It's okay to call str(df.2), and apparently only V1 and V3 reach my request.



    str(df.2)

    # 'data.frame': 5 obs. of 4 variables:
    # $ V1: int 1 2 3 4 5
    # $ V2: int 6 7 8 9 10
    # $ V3: chr "11" "12" "13" "14" ...
    # $ V4:Formal class 'factor' [package "methods"] with 3 slots
    # .. ..@ .Data : int 16 17 18 19 20
    # .. ..@ levels : chr
    # .. ..@ .S3Class: chr "factor"


    Why cannot as function deal with classes numeric and factor?










    share|improve this question


























      5












      5








      5


      4






      I think this is a simple question but I haven't found a suitable solution. To begin with a set of simplified data :



      df <- as.data.frame(matrix(1:20, 5, 4))
      str(df)

      # 'data.frame': 5 obs. of 4 variables:
      # $ V1: int 1 2 3 4 5
      # $ V2: int 6 7 8 9 10
      # $ V3: int 11 12 13 14 15
      # $ V4: int 16 17 18 19 20


      We can see that all the classes are the integer. What I wanna achieve is converting the 4 classes to integer, numeric, character, and factor respectively. Of course, I can use



      df$V1 <- as.XXX(df$V1)


      for each column, but I think it's inefficient.



      Expected Output



      # 'data.frame': 5 obs. of 4 variables:
      # $ V1: int 1 2 3 4 5
      # $ V2: num 6 7 8 9 10
      # $ V3: chr "11" "12" "13" "14" ...
      # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5



      Question 2



      I reference @joran's answer in R Assign (or copy) column classes from a data frame to another and run the following code :



      myclass <- c("integer", "numeric", "character", "factor")
      df.2 <- df
      df.2 <- mapply(FUN = as, df.2, myclass, SIMPLIFY = F)


      When I call df.2, an error appears :




      Error in as.character.factor(x) : malformed factor




      However, It's okay to call str(df.2), and apparently only V1 and V3 reach my request.



      str(df.2)

      # 'data.frame': 5 obs. of 4 variables:
      # $ V1: int 1 2 3 4 5
      # $ V2: int 6 7 8 9 10
      # $ V3: chr "11" "12" "13" "14" ...
      # $ V4:Formal class 'factor' [package "methods"] with 3 slots
      # .. ..@ .Data : int 16 17 18 19 20
      # .. ..@ levels : chr
      # .. ..@ .S3Class: chr "factor"


      Why cannot as function deal with classes numeric and factor?










      share|improve this question
















      I think this is a simple question but I haven't found a suitable solution. To begin with a set of simplified data :



      df <- as.data.frame(matrix(1:20, 5, 4))
      str(df)

      # 'data.frame': 5 obs. of 4 variables:
      # $ V1: int 1 2 3 4 5
      # $ V2: int 6 7 8 9 10
      # $ V3: int 11 12 13 14 15
      # $ V4: int 16 17 18 19 20


      We can see that all the classes are the integer. What I wanna achieve is converting the 4 classes to integer, numeric, character, and factor respectively. Of course, I can use



      df$V1 <- as.XXX(df$V1)


      for each column, but I think it's inefficient.



      Expected Output



      # 'data.frame': 5 obs. of 4 variables:
      # $ V1: int 1 2 3 4 5
      # $ V2: num 6 7 8 9 10
      # $ V3: chr "11" "12" "13" "14" ...
      # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5



      Question 2



      I reference @joran's answer in R Assign (or copy) column classes from a data frame to another and run the following code :



      myclass <- c("integer", "numeric", "character", "factor")
      df.2 <- df
      df.2 <- mapply(FUN = as, df.2, myclass, SIMPLIFY = F)


      When I call df.2, an error appears :




      Error in as.character.factor(x) : malformed factor




      However, It's okay to call str(df.2), and apparently only V1 and V3 reach my request.



      str(df.2)

      # 'data.frame': 5 obs. of 4 variables:
      # $ V1: int 1 2 3 4 5
      # $ V2: int 6 7 8 9 10
      # $ V3: chr "11" "12" "13" "14" ...
      # $ V4:Formal class 'factor' [package "methods"] with 3 slots
      # .. ..@ .Data : int 16 17 18 19 20
      # .. ..@ levels : chr
      # .. ..@ .S3Class: chr "factor"


      Why cannot as function deal with classes numeric and factor?







      r dataframe






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 10 '18 at 19:03







      Darren Tsai

















      asked Nov 10 '18 at 18:24









      Darren TsaiDarren Tsai

      1,420321




      1,420321






















          2 Answers
          2






          active

          oldest

          votes


















          7














          We can use mapply and provide the functions as a list to convert the columns.



          df <- as.data.frame(matrix(1:20, 5, 4))

          df <- mapply(function(x, FUN) FUN(x),
          df,
          list(as.integer, as.numeric, as.character, as.factor),
          SIMPLIFY = FALSE)
          str(df)
          # 'data.frame': 5 obs. of 4 variables:
          # $ V1: int 1 2 3 4 5
          # $ V2: num 6 7 8 9 10
          # $ V3: chr "11" "12" "13" "14" ...
          # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5





          share|improve this answer























          • So great! Thank you so much! Do you mind explaining why the function as cannot work on numeric and factor ?

            – Darren Tsai
            Nov 10 '18 at 18:57











          • @DarrenTsai I am not familiar with the use of as function in this way. I hope others can help.

            – www
            Nov 10 '18 at 18:58


















          1














          If you don't exclude the for loop method, try this :



          df <- as.data.frame(matrix(1:20, 5, 4))
          type <- c("integer", "numeric", "character", "factor")
          for(i in 1:ncol(df))
          call <- paste("as", type[i], sep = ".")
          df[[i]] <- do.call(call, list(df[[i]]))


          str(df)

          # 'data.frame': 5 obs. of 4 variables:
          # $ V1: int 1 2 3 4 5
          # $ V2: num 6 7 8 9 10
          # $ V3: chr "11" "12" "13" "14" ...
          # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5





          share|improve this answer






















            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53242083%2fconvert-multiple-column-classes%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            7














            We can use mapply and provide the functions as a list to convert the columns.



            df <- as.data.frame(matrix(1:20, 5, 4))

            df <- mapply(function(x, FUN) FUN(x),
            df,
            list(as.integer, as.numeric, as.character, as.factor),
            SIMPLIFY = FALSE)
            str(df)
            # 'data.frame': 5 obs. of 4 variables:
            # $ V1: int 1 2 3 4 5
            # $ V2: num 6 7 8 9 10
            # $ V3: chr "11" "12" "13" "14" ...
            # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5





            share|improve this answer























            • So great! Thank you so much! Do you mind explaining why the function as cannot work on numeric and factor ?

              – Darren Tsai
              Nov 10 '18 at 18:57











            • @DarrenTsai I am not familiar with the use of as function in this way. I hope others can help.

              – www
              Nov 10 '18 at 18:58















            7














            We can use mapply and provide the functions as a list to convert the columns.



            df <- as.data.frame(matrix(1:20, 5, 4))

            df <- mapply(function(x, FUN) FUN(x),
            df,
            list(as.integer, as.numeric, as.character, as.factor),
            SIMPLIFY = FALSE)
            str(df)
            # 'data.frame': 5 obs. of 4 variables:
            # $ V1: int 1 2 3 4 5
            # $ V2: num 6 7 8 9 10
            # $ V3: chr "11" "12" "13" "14" ...
            # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5





            share|improve this answer























            • So great! Thank you so much! Do you mind explaining why the function as cannot work on numeric and factor ?

              – Darren Tsai
              Nov 10 '18 at 18:57











            • @DarrenTsai I am not familiar with the use of as function in this way. I hope others can help.

              – www
              Nov 10 '18 at 18:58













            7












            7








            7







            We can use mapply and provide the functions as a list to convert the columns.



            df <- as.data.frame(matrix(1:20, 5, 4))

            df <- mapply(function(x, FUN) FUN(x),
            df,
            list(as.integer, as.numeric, as.character, as.factor),
            SIMPLIFY = FALSE)
            str(df)
            # 'data.frame': 5 obs. of 4 variables:
            # $ V1: int 1 2 3 4 5
            # $ V2: num 6 7 8 9 10
            # $ V3: chr "11" "12" "13" "14" ...
            # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5





            share|improve this answer













            We can use mapply and provide the functions as a list to convert the columns.



            df <- as.data.frame(matrix(1:20, 5, 4))

            df <- mapply(function(x, FUN) FUN(x),
            df,
            list(as.integer, as.numeric, as.character, as.factor),
            SIMPLIFY = FALSE)
            str(df)
            # 'data.frame': 5 obs. of 4 variables:
            # $ V1: int 1 2 3 4 5
            # $ V2: num 6 7 8 9 10
            # $ V3: chr "11" "12" "13" "14" ...
            # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Nov 10 '18 at 18:43









            wwwwww

            26k112240




            26k112240












            • So great! Thank you so much! Do you mind explaining why the function as cannot work on numeric and factor ?

              – Darren Tsai
              Nov 10 '18 at 18:57











            • @DarrenTsai I am not familiar with the use of as function in this way. I hope others can help.

              – www
              Nov 10 '18 at 18:58

















            • So great! Thank you so much! Do you mind explaining why the function as cannot work on numeric and factor ?

              – Darren Tsai
              Nov 10 '18 at 18:57











            • @DarrenTsai I am not familiar with the use of as function in this way. I hope others can help.

              – www
              Nov 10 '18 at 18:58
















            So great! Thank you so much! Do you mind explaining why the function as cannot work on numeric and factor ?

            – Darren Tsai
            Nov 10 '18 at 18:57





            So great! Thank you so much! Do you mind explaining why the function as cannot work on numeric and factor ?

            – Darren Tsai
            Nov 10 '18 at 18:57













            @DarrenTsai I am not familiar with the use of as function in this way. I hope others can help.

            – www
            Nov 10 '18 at 18:58





            @DarrenTsai I am not familiar with the use of as function in this way. I hope others can help.

            – www
            Nov 10 '18 at 18:58













            1














            If you don't exclude the for loop method, try this :



            df <- as.data.frame(matrix(1:20, 5, 4))
            type <- c("integer", "numeric", "character", "factor")
            for(i in 1:ncol(df))
            call <- paste("as", type[i], sep = ".")
            df[[i]] <- do.call(call, list(df[[i]]))


            str(df)

            # 'data.frame': 5 obs. of 4 variables:
            # $ V1: int 1 2 3 4 5
            # $ V2: num 6 7 8 9 10
            # $ V3: chr "11" "12" "13" "14" ...
            # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5





            share|improve this answer



























              1














              If you don't exclude the for loop method, try this :



              df <- as.data.frame(matrix(1:20, 5, 4))
              type <- c("integer", "numeric", "character", "factor")
              for(i in 1:ncol(df))
              call <- paste("as", type[i], sep = ".")
              df[[i]] <- do.call(call, list(df[[i]]))


              str(df)

              # 'data.frame': 5 obs. of 4 variables:
              # $ V1: int 1 2 3 4 5
              # $ V2: num 6 7 8 9 10
              # $ V3: chr "11" "12" "13" "14" ...
              # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5





              share|improve this answer

























                1












                1








                1







                If you don't exclude the for loop method, try this :



                df <- as.data.frame(matrix(1:20, 5, 4))
                type <- c("integer", "numeric", "character", "factor")
                for(i in 1:ncol(df))
                call <- paste("as", type[i], sep = ".")
                df[[i]] <- do.call(call, list(df[[i]]))


                str(df)

                # 'data.frame': 5 obs. of 4 variables:
                # $ V1: int 1 2 3 4 5
                # $ V2: num 6 7 8 9 10
                # $ V3: chr "11" "12" "13" "14" ...
                # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5





                share|improve this answer













                If you don't exclude the for loop method, try this :



                df <- as.data.frame(matrix(1:20, 5, 4))
                type <- c("integer", "numeric", "character", "factor")
                for(i in 1:ncol(df))
                call <- paste("as", type[i], sep = ".")
                df[[i]] <- do.call(call, list(df[[i]]))


                str(df)

                # 'data.frame': 5 obs. of 4 variables:
                # $ V1: int 1 2 3 4 5
                # $ V2: num 6 7 8 9 10
                # $ V3: chr "11" "12" "13" "14" ...
                # $ V4: Factor w/ 5 levels "16","17","18",..: 1 2 3 4 5






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Dec 17 '18 at 8:55







                user10800264


































                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53242083%2fconvert-multiple-column-classes%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    𛂒𛀶,𛀽𛀑𛂀𛃧𛂓𛀙𛃆𛃑𛃷𛂟𛁡𛀢𛀟𛁤𛂽𛁕𛁪𛂟𛂯,𛁞𛂧𛀴𛁄𛁠𛁼𛂿𛀤 𛂘,𛁺𛂾𛃭𛃭𛃵𛀺,𛂣𛃍𛂖𛃶 𛀸𛃀𛂖𛁶𛁏𛁚 𛂢𛂞 𛁰𛂆𛀔,𛁸𛀽𛁓𛃋𛂇𛃧𛀧𛃣𛂐𛃇,𛂂𛃻𛃲𛁬𛃞𛀧𛃃𛀅 𛂭𛁠𛁡𛃇𛀷𛃓𛁥,𛁙𛁘𛁞𛃸𛁸𛃣𛁜,𛂛,𛃿,𛁯𛂘𛂌𛃛𛁱𛃌𛂈𛂇 𛁊𛃲,𛀕𛃴𛀜 𛀶𛂆𛀶𛃟𛂉𛀣,𛂐𛁞𛁾 𛁷𛂑𛁳𛂯𛀬𛃅,𛃶𛁼

                    ャフサォクコ ケウ,コ,ワ メ,ロスョノ゙,クネ,フムカヤヲニ,エコ゚ツ ウイオン゙ケワサネォキモュキォウイノンコチ゚メヌナイゥフュ,カヒウネェ ネ,ホノケ,ムュキ ッボーミュハ,チ ツス ィ メウイマヤ,゙ウチ ヅ ロ,ォジヌェ ャヌット ェ,マャ,チナエヒネソキツテ トホヲヲミーァ

                    Node.js puppeteer - Use values from array in a loop to cycle through pages