[R] [External] Data is not properly written in csv file
Richard M. Heiberger
rmh @end|ng |rom temp|e@edu
Tue Jun 22 00:17:22 CEST 2021
copy and paste from pdf usually scrambles tables. this package is probably suffering from that pdf characteristic.
> On Jun 20, 2021, at 11:03, Sri Priya <sri.chocho using gmail.com> wrote:
>
> Dear R Users,
>
> I am working on extracting tables from PDF and I am writing that in a csv
> file. When I executed the code, the tables were not properly written in the
> csv file.
>
> Here is my code:
>
> library(tabulizer)
> # Location of pdf file.
> location <- '
> https://nam10.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkeic.mica-apps.net%2Fwwwisis%2FET_Annual_Reports%2FReligare_Enterprises_Ltd%2FRELIGARE-2017-2018.pdf&data=04%7C01%7Crmh%40temple.edu%7C1025b6434d6f4b4f7b5008d934f99be3%7C716e81efb52244738e3110bd02ccf6e5%7C0%7C0%7C637599069571109750%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=xLxqLIYvnriqWOoENpbWJvFi7wf03aHslYIz0jPZymY%3D&reserved=0
> '
>
> # Extract the table
> out <- extract_tables(location)
> for(i in 1:length(out))
> {
> write.table(out[i], file='Output.csv',append=TRUE, sep=",",quote =
> FALSE)
> }
> I enclosed the screenshot of the output file. In that you can see
> the tables are incomplete.
>
> Any help would be appreciated.
>
> Thanks
> Sripriya.
> <Screenshot.png>______________________________________________
> R-help using 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.
More information about the R-help
mailing list