Dear Jeff,
I want to rbind.
Thanking you,
Yours sincerely,
AKSHAY M KULKARNI
________________________________
From: R-help <r-help-bounces at r-project.org> on behalf of Jeff Newmiller
<jdnewmil at dcn.davis.ca.us>
Sent: Sunday, April 9, 2023 11:57 PM
To: r-help at r-project.org <r-help at 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 <jdnewmil at
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_e4 at
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 at 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 at 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.
[[alternative HTML version deleted]]