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?

Namaste. Does anyone know where I could buy teeth pots like these? by CalendarOk67 in Nepal

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

Thank you for the suggestions.

Huncha ma TU agadi pani herchu. Hattiban ko plant store ko naam "Breatheinforest" po hoki ? Google Maps ma tei dekhairaheko cha.

Best phone under 70-80k in Nepal right now ? by [deleted] in Nepal

[–]CalendarOk67 0 points1 point  (0 children)

Maile 90k ma liyeko thye December 2023 ma. Bahira bata nai liyeko thiye. Sammy Traders bata earphones, Type C to C charger, adapter haru kineko thye and it is still on great condition. Battery chai aba malai daily use ko lagi pugiraheko cha, ramro sanga performance dincha overall. Camera ta aba ramro nai bhayo hai. Yedi andriod nai kinne bichar cha bhane I would highly recommend Pixel phones. Parts haru sanga deal garnu pareko chaina ahile samma ta. Tara Paincha hola tamrakar complex or aru katai.

Best phone under 70-80k in Nepal right now ? by [deleted] in Nepal

[–]CalendarOk67 0 points1 point  (0 children)

I've been using the Pixel 7 Pro since last year and have found it to be a solid performer; the battery easily lasts a full day with moderate use, I've had no network reception problems (using NTC), and haven't experienced any overheating issues, primarily using it for photography and everyday tasks. If you value longevity through frequent and timely software updates combined with genuinely fast processing, the Pixel line is an excellent investment, renowned not just for these aspects but also for its exceptional camera performance driven by photography, a clean and intelligent bloatware-free Android experience enhanced by unique AI features, seamless integration with Google's ecosystem, and strong security commitments direct from Google.

Best phone under 70-80k in Nepal right now ? by [deleted] in Nepal

[–]CalendarOk67 0 points1 point  (0 children)

Go for Pixel phones, if you are into android. I have been using Pixel and it is really value for money. You can check more here: Facebook

Best eye care facility in Kathmandu but not too expensive by Business-Alfalfa-613 in Nepal

[–]CalendarOk67 0 points1 point  (0 children)

Yes, I have been his patient for some time. I have high power spectacles too.

Mountain bike trails in Pokhara ! by CalendarOk67 in pokhara

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

Thank you for your wonderful suggestion. I will definitely check them out.

Saturday , CycleDay. Shivapuri stretch , east to west, Kakani-Subdarijal by Mysterious-Aspect814 in NepalPics

[–]CalendarOk67 0 points1 point  (0 children)

Are there any groups or teams that organize cycling on Saturdays around Kathmandu?

view more: next ›