Help in modifying code to extract data from url

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Help in modifying code to extract data from url

Bhaskar Mitra
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Help in modifying code to extract data from url

Jim Lemon-4
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Help in modifying code to extract data from url

Richard O'Keefe-2
In reply to this post by Bhaskar Mitra
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Help in modifying code to extract data from url

David Winsemius
In reply to this post by Jim Lemon-4
Several authors hav addressed this problem with names that resemble
"rbindfill". In my machine I find four instances:

??rbindfill

Help pages:
ffbase::ffdfrbind.fill        rbind for ffdf where missing columns are
added if not available in one of the ffdf objects
plyr::rbind.fill        Combine data.frames by row, filling in missing
columns.
plyr::rbind.fill.matrix        Bind matrices by row, and fill missing
columns with NA.
rockchalk::rbindFill        Stack together data frames


--

David.

On 5/20/21 2:19 AM, Jim Lemon wrote:

> Hi Bhaskar,
> If you are using read.table or similar, see the "fill=" argument.
>
> Jim
>
> On Thu, May 20, 2021 at 9:54 AM Bhaskar Mitra <[hidden email]> wrote:
>> Hello Everyone,
>>
>> I am trying to extract data from a url. The codes work well when the
>> data structure is as follows:
>>
>> X Y
>> 1 2
>> 1 5
>> 1 6
>> 1 7
>> 3 4
>>
>> However, the code fails when the data structure has no number
>> under the 2nd column (shown below).I get the following error:
>>
>> "Error in data.frame(..., check.names = FALSE) :
>>    arguments imply differing number of rows: 242, 241"
>>
>>
>> X Y
>> 1 2
>> 1
>> 1
>> 1 7
>> 3 4
>>
>> Can anyone please help me in how I can modify the codes ( shown below) to
>> adjust for the above mentioned condition
>> in the data structure.
>>
>> library(rjson)
>>
>> url <- "abcd.com"
>> json_data <- fromJSON(file= url)
>> d3 <- lapply(json_data[[2]], function(x) c(x["data"]))
>> d3 <- do.call(rbind, d3)
>> X_Dataframe = as.data.frame(unlist(d3[[1]]))
>> b <- do.call("cbind", split(X_Dataframe, rep(c(1, 2), length.out =
>> nrow(X_Dataframe))))
>>
>>
>> regards,
>> bhaskar
>>
>>          [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> [hidden email] 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.
> ______________________________________________
> [hidden email] 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.

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: Help in modifying code to extract data from url

Bhaskar Mitra
CONTENTS DELETED
The author has deleted this message.