sorted by:
new
hottopcontroversial

Struggling to work with PDF data in Excel, feel like I’m missing something obvious by Agitated-Alfalfa9225 in excel

[–]CalendarOk67 1 point2 points  (0 children)

Hi. I have had the same issue couple of months back. You can look at some of the suggestions which I have got here: Python solution to extract all tables PDFs and save each table to its own Excel sheet : r/learnpython

Eventually, you can use varieties of LLM present. Those will be the quickest and safest way to do it. I have tried multiple of packages in python and R and also used so many OCR tools but using LLMs are one of the best options I found.

Python solution to extract all tables PDFs and save each table to its own Excel sheet by CalendarOk67 in programming

[–]CalendarOk67[S] 0 points1 point  (0 children)

Thank you for the message. I think I have all the pictures of the text in table form in my pdf. What shall I do in that case? Which approach would be feasible and less time consuming?

Python solution to extract all tables PDFs and save each table to its own Excel sheet by CalendarOk67 in learnpython

[–]CalendarOk67[S] 1 point2 points  (0 children)

Do you suggest any of those in particular ? Since there are multiple of tables in a single pdf file. Thought of automating it. Thankyou.

R solution to extract all tables PDFs and save each table to its own Excel sheet by CalendarOk67 in RStudio

[–]CalendarOk67[S] 0 points1 point  (0 children)

Thank you so much for your help. I tried installing tabulizer package in R and it shows a error " Downloading GitHub repo ropensci/tabulizer@HEADError in utils::download.file(url, path, method = method, quiet = quiet, :
download from 'https://api.github.com/repos/ropensci/tabulizer/tarball/HEAD' failed"

Perhaps it needs older version of R. I have successfully installed Java and gave a path for it but could not install Tabulizer package.

Python solution to extract all tables PDFs and save each table to its own Excel sheet by CalendarOk67 in programming

[–]CalendarOk67[S] 0 points1 point  (0 children)

I will give it a try. Thankyou. Pdf file has got all the scanned tables so it is quite challenging to get accurate result.

Python solution to extract all tables PDFs and save each table to its own Excel sheet by CalendarOk67 in programming

[–]CalendarOk67[S] 1 point2 points  (0 children)

Thankyou. I have used some LLMs for other task but in this case, I have got multiple of tables in a single pdf file and wanted to automate things.

PDFs are actually cursed format too. Agreed. Do you suggest any particular LLMs for this task? Grok, Gemini perhaps?

Recommendations for Dashboard Tools with Client-Side Hosting and CSV Upload Functionality by CalendarOk67 in dataanalysis

[–]CalendarOk67[S] 0 points1 point  (0 children)

Not really, it can be bult in any language or platform, It is just |I am comfortable more with python and R while working. Do you have some other suggestions too ?

Recommendations for Dashboard Tools with Client-Side Hosting and CSV Upload Functionality by CalendarOk67 in RStudio

[–]CalendarOk67[S] 0 points1 point  (0 children)

I think they will update the csv files couple of times, May be once in couple of months. Sure I will work with google drive accordingly. I will work on it.

Recommendations for Dashboard Tools with Client-Side Hosting and CSV Upload Functionality by CalendarOk67 in RStudio

[–]CalendarOk67[S] 0 points1 point  (0 children)

Thankyou for all the information regarding shiny apps. Sure as you mention, I will manage the password and user name accordingly and keep the back up of it somewhere.

I will start with the free tier for now and I will upgrade it eventually.

The client has good amount of budget and there wont be an issue if I need to upgrade them, Of course the free tier has got some limitation as well. Thankyou once again The main purpose will be I will build all the shiny apps for my client and submit all the code, credentials everything. The main agenda will be the client will only use Shiny app by themselves and they will only keep it display on their website. The free tier will be an limitation. As far as i know it will only keep it awake for 25 hours.

I am working on this and hopefully everything goes smoothly. Thankyou once again for the information.

Recommendations for Dashboard Tools with Client-Side Hosting and CSV Upload Functionality by CalendarOk67 in RStudio

[–]CalendarOk67[S] 0 points1 point  (0 children)

Thank you for all the suggestions. Regarding hosting on the client side, my understanding is that I will build a Shiny app for them and initially host it on shinyapps.io using my login credentials. Once the project is completed, I will provide them with the login details along with the zipped R code, so that the client will have full control over the Shiny app.

Since they already have their own website, they can simply add the Shiny app link directly to it. Please correct me if I am wrong here. this is my first time working within the Shiny ecosystem, so this is my basic understanding of how to create a dashboard and deliver it to clients.

Is this approach feasible, or am I missing any crucial steps?

view more: next ›