pyExcel | Python wrapper for Microsoft Excel

i wrote a python code to automate a conversion, firstly i get a .pdf, then i covert o a .csv, get the tables i want, and then i convert it to .xlsx. Does anyone know if i can export the headers i have in .csv to the .xlsx file?

here's the .csv file: .csv table

here's the .xlsx export: .xlsx table

I'm adding the headers using pandas:

I want to make use of a promising NN I found at towardsdatascience for my case study.

The data shapes I have are:

I am successfully writing dataframes to Excel using df.to_excel(). Unfortunately, this is slow and consumes gobs of memory. The larger the dataset, the more memory it consumes, until (with the largest datasets I need to deal with) the server starves for resources.

I found that using the df.to_csv() method instead offers the convenient chunksize=nnnn argument. This is far faster and consumes almost no extra memory. Wonderful! I'll just write initially to .csv, then convert the .csv to .xlsx in another process. I tried doing it with openpyxl, but every solution I found iterated through the csv data one row at a time, appending to a Workbook sheet, e.g.

I want to open a simple excel file using PyExcel and here is my code

I am reading a .xlxs file using pandas library and extracting the dataframe. Now I am trying to create a file with .ods extension and write the dataframe into it using pyexcel_ods library. Here is my code :--

I am trying to add 80 subdirectories within a given directory.

Each directory needs the following sub directories:

EDIT 2: After a long time, solved! See answer below.

EDIT: I am sorry to say that the the problems went away "on their own" between yesterday and today, without me having done anything. Great non-deterministic lesson to learn here... Bonus fun: the "could not bind IPv6 socket" error still appears in the error logs, so this was probably not even the problem in the first place.

I have a problem with a previously functioning docker PGSQL image. Until an uninspired rebuild yesterday ( :-D ), I've used this build successfully for the last 5+ months.

My system:

• Ubuntu 17.04 64b
• PGSQL 9.6.4
• Docker version 17.11.0-ce, build 1caf76c
• I am mapping host port 5433 to container port 5432

The problem (snippet from the PGSQL logs):

...

LOG: could not bind IPv6 socket: Cannot assign requested address

HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.

...

This is what ss is telling me (when the container is running, obviously):

I'm using pyexcel and when I get a sheet from a dictionary it gets sorted alphabetically. How can I disable that feature?

I tried searching for information about sorting in the documentation but didn't find anything.

For example in this code I have two rows: Vegetables and Fruits, in that order. But in the output it changes the order sorting it alphabetically.

Code:

I am trying to copy data from one excel file to another automatically using python, currently i have to manually update the date in the excel file name every morning. Is there a way to automatically update the date in the excel file name. I am very new to any form of programming, trying to learn to keep my job.

I have tried to use the time date function and declare this as a variable and copy this into code but no luck