fingertipsR icon indicating copy to clipboard operation
fingertipsR copied to clipboard

fingertips_data function for GP profiles

Open stephshadwell opened this issue 6 years ago • 4 comments

We are trying to run the fingertips_data function for the gp profiles?

df <- fingertips_data(ProfileID = 20, AreaTypeID = 7) however this returns the following error message: Error: object 'Indicator Name' not found

i have tried running no specifying the AreaTypeID df <- fingertips_data(ProfileID = 20)

but this then returns a dataframe with 0 obs of 26 variables.

I have tried running for other profiles such as PHOF & Local Health but don't seem to be having the same issue.

I an currently using version 0.2.6 of the package (which i believe is the latest version)

stephshadwell avatar Jun 13 '19 08:06 stephshadwell

Hi @stephshadwell, having spoken to the Fingertips developer team I can provide their response to you regarding the first issue (df <- fingertips_data(ProfileID = 20, AreaTypeID = 7)):

The issue is due to the amount of data being returned. If the server returned that data as a CSV then it would be a file of 1.7GB. The application on the server is throwing an OutOfMemory exception.

The answer to why df <- fingertips_data(ProfileID = 20) returns 0 records is because the default AreaTypeID is 102, which doesn't exist in the GP Profiles.

I think it is worth leaving this issue open so others can see that it is unresolved if they come across the same issue...

Thanks for raising it. Seb

sebastian-fox avatar Jun 14 '19 12:06 sebastian-fox

thanks @sebastian-fox

stephshadwell avatar Jun 14 '19 13:06 stephshadwell

@sebastian-fox is there any update on this. Josh has raised the same question on our East of England slack channel this week, as he is having issues in Norfolk

stephshadwell avatar Mar 11 '20 11:03 stephshadwell

@stephshadwell - apologies for the delay, I've been away. I've spoken with the developers and they have some ideas for how to proceed. They've created a ticket for it and will try to look at it in the next few weeks

sebastian-fox avatar Mar 23 '20 17:03 sebastian-fox