I don't know... I have never used tabulizer (which is no longer on CRAN anyway).
In general you would provide an argument to the data import function that would tell it to expect a header. I suspect you will have to set the names(IDT[[4]]) <- whatever it should be and remove the first row from the data frame. On April 9, 2023 12:03:36 PM PDT, akshay kulkarni <akshay...@hotmail.com> wrote: >Dear Jeff, > Thanks for your reply. > >I have the following: > >> colnames(IDT[[4]]) >[1] "X168" "TATA.MOTORS.LIMITED" "TATAMOTORS" "X4" > >THe above has to be the first row of IDT[[4]]. The first row is getting parsed >as the column name. How do you make that the first row of IDT[[4]]? > >Thanking you, >Yours sincerely, >AKSHAY M KULKARNI >________________________________ >From: Jeff Newmiller <jdnew...@dcn.davis.ca.us> >Sent: Monday, April 10, 2023 12:27 AM >To: akshay kulkarni <akshay...@hotmail.com>; r-help@r-project.org ><r-help@r-project.org> >Subject: Re: [R] extracting pdf tables... > >Your code used cbind. My first answer was appropriate for rbind. > >So you still need to figure out how to deal with the different columns in the >tables, which requires more knowledge about their contents than we have. > >On April 9, 2023 11:43:01 AM PDT, akshay kulkarni <akshay...@hotmail.com> >wrote: >>Dear Jeff, >> I want to rbind. >> >>Thanking you, >>Yours sincerely, >>AKSHAY M KULKARNI >>________________________________ >>From: R-help <r-help-boun...@r-project.org> on behalf of Jeff Newmiller >><jdnew...@dcn.davis.ca.us> >>Sent: Sunday, April 9, 2023 11:57 PM >>To: r-help@r-project.org <r-help@r-project.org> >>Subject: Re: [R] extracting pdf tables... >> >>Sorry, did not read closely enough. >> >>Did you want rbind (which has no problem with different numbers of rows) or >>merge (which requires that there be key columns that can be aligned by >>repeating data)? >> >>On April 9, 2023 10:49:09 AM PDT, Jeff Newmiller <jdnew...@dcn.davis.ca.us> >>wrote: >>>Clearly the column names are different. You need to decide what to do about >>>that. Choose the subset of dataframes where the column names are the same? >>>Rename columns? Omit some columns? Add missing columns filled with NA? >>> >>>On April 9, 2023 10:22:32 AM PDT, akshay kulkarni <akshay...@hotmail.com> >>>wrote: >>>>Dear members, >>>> I am extracting a pdf table by the following >>>> code: >>>> >>>>> library(tabulizer) >>>>> IDT <- >>>>> extract_tables("https://www.canmoney.in/pdf/INTRADAYLEVERAGE-20220531-latest.pdf",output >>>>> = "data.frame") >>>> >>>>It returns 4 different data frames which I want to combine them and make >>>>one data frame. But when I run this: >>>> >>>>> rbind(IDT[[1]],IDT[[2]],IDT[[3]],IDT[[4]]) >>>> Error in match.names(clabs, names(xi)) : >>>>names do not match previous names >>>> >>>>Also: >>>> >>>>> class(IDT[[1]]) >>>>[1] "data.frame" >>>> >>>>> cbind(IDT[[1]],IDT[[2]],IDT[[3]],IDT[[4]],make.row.names = FALSE) >>>> Error in data.frame(..., check.names = FALSE) : >>>>arguments imply differing number of rows: 55, 56, 30, 1 >>>> >>>>Can anyone please help me to combine all these 4 different data frames? >>>> >>>>Thanking you, >>>>Yours sincerely, >>>>AKSHAY M KULKARNI >>>> >>>> [[alternative HTML version deleted]] >>>> >>>>______________________________________________ >>>>R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >>>>https://stat.ethz.ch/mailman/listinfo/r-help >>>>PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >>>>and provide commented, minimal, self-contained, reproducible code. >>> >> >>-- >>Sent from my phone. Please excuse my brevity. >> >>______________________________________________ >>R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >>https://stat.ethz.ch/mailman/listinfo/r-help >>PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >>and provide commented, minimal, self-contained, reproducible code. > >-- >Sent from my phone. Please excuse my brevity. -- Sent from my phone. Please excuse my brevity. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.