Python Forum
read multiple .xlsx files and text files in a directory
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
read multiple .xlsx files and text files in a directory
#11
(Jun-06-2017, 08:43 PM)nilamo Wrote: 1) don't recommend pandas, but mostly because...
2) I'm not even really sure what it is  

From what I've seen it's basically numpy, but more complicated and without any additional benefits.
Ehhh then maybe look into it,it's for sure not just NumPy with additional benefits Dodgy

That said Openpyxl is a great tool for working with Excel files.
It's a library that's specialized to work with Excel files.

Pandas is a great tool that can read a bunch of formats(can take some effort to install for beginners).
Need also to use Jupyter Notebook to get the most out of Pandas then a Dataframe look just like Excel.
Common Excel Tasks Demonstrated in Pandas

This task can solved both,so not so much to discuss about Wink
Reply
#12
Well, just an update, I have solved my issue with openpyxl but its just that openpyxl is not very helpful in saving images (as mentioned in its documentation) from original excel file and it disappears when you save the workbook.
Any other libraries that is compatible with xlsx files, can modify/append worksheets and save it in original form with images/formatting ?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Import multiple CSV files into pandas Krayna 0 1,694 May-20-2021, 04:56 PM
Last Post: Krayna
  Python - Pandas writing blank files to file tdunphy 0 1,972 Jan-14-2021, 12:11 AM
Last Post: tdunphy
  Most Compatible Text Editor to Handle Large Files? Robotguy 2 2,336 Aug-18-2020, 03:51 PM
Last Post: FortyTwo
  Creating many csv files from Pandas EMA 0 1,610 Jul-26-2020, 06:39 PM
Last Post: EMA
  Loading multiple JSON files to create a csv 0LI5A3A 0 2,081 Jun-28-2020, 10:35 PM
Last Post: 0LI5A3A
  Binning data to files Kappel 4 2,367 Jun-22-2020, 06:25 PM
Last Post: Kappel
  Filter rows by multiple text conditions in another data frame i.e contains strings an Pan 0 2,131 Jun-09-2020, 06:05 AM
Last Post: Pan
  Can't read text file with pandas zinho 6 12,000 May-24-2020, 06:13 AM
Last Post: azajali43
  XLSX file with multiple sheets to josn file ovidius 2 2,192 Apr-05-2020, 09:22 AM
Last Post: ovidius
  Can python read Marathi text files and summarize them? mcp111 0 1,783 Mar-18-2020, 08:58 AM
Last Post: mcp111

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020