🌐 Mailman 3 May 2020 - Python-list - python.org

Issues regarding running of application.
by Meet Agrawal May 27, 2020

May 27, 2020

I have tried and installed the python application a lot of times but after the installation get completed and I try to run the application, it say that api-ms-win-crt-runtime-l1-1-0.dll is missing from your computer. Please tell me a way out.

5 4

Re: Behaviour of os.path.join
by Ben Bacarisse May 27, 2020

May 27, 2020

Roel Schroeven <roel(a)roelschroeven.net> writes: > Ben Bacarisse schreef op 27/05/2020 om 17:53: >> There is well-known (*nix) software that relies on a/b/c/ meaning >> something different to a/b/c but I don't know anyone who thinks this is >> a good idea. It causes no end of confusion. > > rsync? I always have to look up whether or not I need to use a > trailing / on the source directory. It's confusing indeed. That was the one I was thinking of. -- Ben.

1 0

Re: Behaviour of os.path.join
by BlindAnagram May 27, 2020

May 27, 2020

On 27/05/2020 09:13, Barry Scott wrote: > > >> On 26 May 2020, at 18:01, BlindAnagram <blindanagram(a)nowhere.com> wrote: >> >> On 26/05/2020 17:09, Stefan Ram wrote: >>> Mats Wichmann <mats(a)python.org> writes: >>>> an absolute path is one that starts with the pathname separator. >>> >>> The Python Library Reference does not use the term >>> "pathname separator". It uses "directory separator" >>> (os.sep) and "filename separator" ('/' on Unix). >>> >>> On Windows: >>> >>> |>>> import pathlib >>> |>>> import os >>> |>>> pathlib.PureWindowsPath('\\').is_absolute() >>> |False >>> |>>> pathlib.PureWindowsPath(os.sep).is_absolute() >>> |False >>> |>>> pathlib.PureWindowsPath('/').is_absolute() >>> |False >> >> Thanks, that seems to suggest that there is an issue and that I should >> hence submit this as an issue. > > Can you post the a link to the issue please? The issue that I raised here was whether the behaviour of os.path.join() in treating the Windows directory separator '\\' as an absolute path should be considered a bug. The behaviour of join came up for me when I tried to use the os.path functions to create a path that could only ever be used as a directory and never a file. The only way that I found to designate a path as a directory path was to add '\\' at the end. But this doesn't work in using os.path becaause the other os.path functions just strip it off and turn the directories back into files. I had hoped that join's documented use of an empty final parameter to add '\\' might behave differently but it gets stripped off as well :-( I thought that the description of pathlib behaviour above suported the view that the os.path.joing behaviour is a bug, and in a sense it does, but more importantly it an indication that pathib, not os.path, should be the module of choice for anyone who spends a lot of time manipulating paths on Windows.

6 10

Managing plug-ins
by DL Neil May 27, 2020

May 27, 2020

Please recommend a library which will manage plug-ins. (Regret that searching PyPi or using a web SE results in an overwhelming number of 'false positives') Not wanting to 'reinvent the wheel, have been looking for an 'approved' way to manage a set of previously-prepared routines plus user-added functionality: - user selects particular type of analysis (cmdLN) - take that string and convert to a function/method - 'plug-in' code could be located within application - 'plug-in' could be 'included' from user - interface standardisation/checking not part of question - Python3 Application is statistical analysis. Users want to control aspects such as data selection/inclusion policies, other data pre-processing/massaging, distribution curve to be applied, and similar. NB not looking for stats-code, but to easily manage a range of plug-ins from which users may select to suit their particular research objective. -- Regards, =dn

3 3

Re: Write tables from Word (.docx) to Excel (.xlsx) using xlsxwriter
by BBT May 27, 2020

May 27, 2020

On Thursday, 28 May 2020 02:40:49 UTC+8, Peter Otten wrote: > BBT wrote: > > > On Thursday, 28 May 2020 01:36:26 UTC+8, Peter Otten wrote: > >> BBT wrote: > >> > >> > I am trying to parse a word (.docx) for tables, then copy these tables > >> > over to excel using xlsxwriter. This is my code: > >> > > >> > from docx.api import Document > >> > import xlsxwriter > >> > > >> > document = Document('/Users/xxx/Documents/xxx/Clauses Sample - Copy v1 > >> > - for merge.docx') tables = document.tables > >> > > >> > wb = xlsxwriter.Workbook('C:/Users/xxx/Documents/xxx/test clause > >> > retrieval.xlsx') Sheet1 = wb.add_worksheet("Compliance") > >> > index_row = 0 > >> > > >> > print(len(tables)) > >> > > >> > for table in document.tables: > >> > data = [] > >> > keys = None > >> > for i, row in enumerate(table.rows): > >> > text = (cell.text for cell in row.cells) > >> > > >> > if i == 0: > >> > keys = tuple(text) > >> > continue > >> > row_data = dict(zip(keys, text)) > >> > data.append(row_data) > >> > #print (data) > >> > #big_data.append(data) > >> > Sheet1.write(index_row,0, str(row_data)) > >> > index_row = index_row + 1 > >> > > >> > print(row_data) > >> > > >> > wb.close() > >> > > >> > > >> > This is my desired output: https://i.stack.imgur.com/9qnbw.png > >> > > >> > However, here is my actual output: https://i.stack.imgur.com/vpXej.png > >> > > >> > I am aware that my current output produces a list of string instead. > >> > > >> > Is there anyway that I can get my desired output using xlsxwriter? > >> > >> I had to simulate docx.api. With that caveat the following seems to work: > >> > >> import xlsxwriter > >> > >> # begin simulation of > >> # from docx.api import Document > >> > >> class Cell: > >> def __init__(self, text): > >> self.text = text > >> > >> class Row: > >> def __init__(self, cells): > >> self.cells = [Cell(c) for c in cells] > >> > >> class Table: > >> def __init__(self, data): > >> self.rows = [ > >> Row(row) for row in data > >> ] > >> > >> class Document: > >> def __init__(self): > >> self.tables = [ > >> Table([ > >> ["Hello", "Test"], > >> ["est", "ing"], > >> ["gg", "ff"] > >> ]), > >> Table([ > >> ["Foo", "Bar", "Baz"], > >> ["ham", "spam", "jam"] > >> ]) > >> ] > >> > >> document = Document() > >> > >> # end simulation > >> > >> wb = xlsxwriter.Workbook("tmp.xlsx") > >> sheet = wb.add_worksheet("Compliance") > >> > >> offset = 0 > >> for table in document.tables: > >> for y, row in enumerate(table.rows): > >> for x, cell in enumerate(row.cells): > >> sheet.write(y + offset, x, cell.text) > >> offset += len(table.rows) + 1 # one empty row between tables > >> > >> wb.close() > > > > > > Hi Peter, thank you for your efforts :) > > > > However, what if there are many tables in the word document, it would be > > tedious to have to code the texts in the tables one by one. Can I instead, > > call on the word document and let Python do the parsing for tables and its > > contents? > > I don't understand. You have docx.api available, so you can replace > > the "simulation" part of my example with just these two lines: > > from docx.api import Document > document = Document('/Users/xxx/Documents/xxx/Clauses Sample - Copy v1 - for merge.docx') > > I should work -- it's just that I cannot be sure it will work because I could > not test it. I tried your code by replacing the Document portion: import xlsxwriter # begin simulation of # from docx.api import Document class Cell: def __init__(self, text): self.text = text class Row: def __init__(self, cells): self.cells = [Cell(c) for c in cells] class Table: def __init__(self, data): self.rows = [ Row(row) for row in data ] class Document: def __init__(self): self.tables = [ Table([ ["Hello", "Test"], ["est", "ing"], ["gg", "ff"] ]), Table([ ["Foo", "Bar", "Baz"], ["ham", "spam", "jam"] ]) ] #document = Document() # end simulation document = Document('/Users/xxx/Documents/xx/Clauses Sample - Copy v1 - for merge.docx') wb = xlsxwriter.Workbook('C:/Users/xxx/Documents/xx/test clause retrieval.xlsx') Sheet1 = wb.add_worksheet("Compliance") offset = 0 for table in document.tables: for y, row in enumerate(table.rows): for x, cell in enumerate(row.cells): sheet.write(y + offset, x, cell.text) offset += len(table.rows) + 1 # one empty row between tables wb.close() But I received an error: TypeError: __init__() takes 1 positional argument but 2 were given

2 1

Re: Write tables from Word (.docx) to Excel (.xlsx) using xlsxwriter
by BBT May 27, 2020

May 27, 2020

On Thursday, 28 May 2020 02:40:49 UTC+8, Peter Otten wrote: > BBT wrote: > > > On Thursday, 28 May 2020 01:36:26 UTC+8, Peter Otten wrote: > >> BBT wrote: > >> > >> > I am trying to parse a word (.docx) for tables, then copy these tables > >> > over to excel using xlsxwriter. This is my code: > >> > > >> > from docx.api import Document > >> > import xlsxwriter > >> > > >> > document = Document('/Users/xxx/Documents/xxx/Clauses Sample - Copy v1 > >> > - for merge.docx') tables = document.tables > >> > > >> > wb = xlsxwriter.Workbook('C:/Users/xxx/Documents/xxx/test clause > >> > retrieval.xlsx') Sheet1 = wb.add_worksheet("Compliance") > >> > index_row = 0 > >> > > >> > print(len(tables)) > >> > > >> > for table in document.tables: > >> > data = [] > >> > keys = None > >> > for i, row in enumerate(table.rows): > >> > text = (cell.text for cell in row.cells) > >> > > >> > if i == 0: > >> > keys = tuple(text) > >> > continue > >> > row_data = dict(zip(keys, text)) > >> > data.append(row_data) > >> > #print (data) > >> > #big_data.append(data) > >> > Sheet1.write(index_row,0, str(row_data)) > >> > index_row = index_row + 1 > >> > > >> > print(row_data) > >> > > >> > wb.close() > >> > > >> > > >> > This is my desired output: https://i.stack.imgur.com/9qnbw.png > >> > > >> > However, here is my actual output: https://i.stack.imgur.com/vpXej.png > >> > > >> > I am aware that my current output produces a list of string instead. > >> > > >> > Is there anyway that I can get my desired output using xlsxwriter? > >> > >> I had to simulate docx.api. With that caveat the following seems to work: > >> > >> import xlsxwriter > >> > >> # begin simulation of > >> # from docx.api import Document > >> > >> class Cell: > >> def __init__(self, text): > >> self.text = text > >> > >> class Row: > >> def __init__(self, cells): > >> self.cells = [Cell(c) for c in cells] > >> > >> class Table: > >> def __init__(self, data): > >> self.rows = [ > >> Row(row) for row in data > >> ] > >> > >> class Document: > >> def __init__(self): > >> self.tables = [ > >> Table([ > >> ["Hello", "Test"], > >> ["est", "ing"], > >> ["gg", "ff"] > >> ]), > >> Table([ > >> ["Foo", "Bar", "Baz"], > >> ["ham", "spam", "jam"] > >> ]) > >> ] > >> > >> document = Document() > >> > >> # end simulation > >> > >> wb = xlsxwriter.Workbook("tmp.xlsx") > >> sheet = wb.add_worksheet("Compliance") > >> > >> offset = 0 > >> for table in document.tables: > >> for y, row in enumerate(table.rows): > >> for x, cell in enumerate(row.cells): > >> sheet.write(y + offset, x, cell.text) > >> offset += len(table.rows) + 1 # one empty row between tables > >> > >> wb.close() > > > > > > Hi Peter, thank you for your efforts :) > > > > However, what if there are many tables in the word document, it would be > > tedious to have to code the texts in the tables one by one. Can I instead, > > call on the word document and let Python do the parsing for tables and its > > contents? > > I don't understand. You have docx.api available, so you can replace > > the "simulation" part of my example with just these two lines: > > from docx.api import Document > document = Document('/Users/xxx/Documents/xxx/Clauses Sample - Copy v1 - for merge.docx') > > I should work -- it's just that I cannot be sure it will work because I could > not test it. I tried your code by replacing the Document portion: import xlsxwriter # begin simulation of # from docx.api import Document class Cell: def __init__(self, text): self.text = text class Row: def __init__(self, cells): self.cells = [Cell(c) for c in cells] class Table: def __init__(self, data): self.rows = [ Row(row) for row in data ] class Document: def __init__(self): self.tables = [ Table([ ["Hello", "Test"], ["est", "ing"], ["gg", "ff"] ]), Table([ ["Foo", "Bar", "Baz"], ["ham", "spam", "jam"] ]) ] #document = Document() # end simulation document = Document('/Users/Ai Shan/Documents/CPFB Work/Clauses Sample - Copy v1 - for merge.docx') wb = xlsxwriter.Workbook('C:/Users/Ai Shan/Documents/CPFB Work/test clause retrieval.xlsx') Sheet1 = wb.add_worksheet("Compliance") offset = 0 for table in document.tables: for y, row in enumerate(table.rows): for x, cell in enumerate(row.cells): sheet.write(y + offset, x, cell.text) offset += len(table.rows) + 1 # one empty row between tables wb.close() But I received an error: TypeError: __init__() takes 1 positional argument but 2 were given

1 0

Re: Write tables from Word (.docx) to Excel (.xlsx) using xlsxwriter
by BBT May 27, 2020

May 27, 2020

On Thursday, 28 May 2020 01:36:26 UTC+8, Peter Otten wrote: > BBT wrote: > > > I am trying to parse a word (.docx) for tables, then copy these tables > > over to excel using xlsxwriter. This is my code: > > > > from docx.api import Document > > import xlsxwriter > > > > document = Document('/Users/xxx/Documents/xxx/Clauses Sample - Copy v1 - > > for merge.docx') tables = document.tables > > > > wb = xlsxwriter.Workbook('C:/Users/xxx/Documents/xxx/test clause > > retrieval.xlsx') Sheet1 = wb.add_worksheet("Compliance") > > index_row = 0 > > > > print(len(tables)) > > > > for table in document.tables: > > data = [] > > keys = None > > for i, row in enumerate(table.rows): > > text = (cell.text for cell in row.cells) > > > > if i == 0: > > keys = tuple(text) > > continue > > row_data = dict(zip(keys, text)) > > data.append(row_data) > > #print (data) > > #big_data.append(data) > > Sheet1.write(index_row,0, str(row_data)) > > index_row = index_row + 1 > > > > print(row_data) > > > > wb.close() > > > > > > This is my desired output: https://i.stack.imgur.com/9qnbw.png > > > > However, here is my actual output: https://i.stack.imgur.com/vpXej.png > > > > I am aware that my current output produces a list of string instead. > > > > Is there anyway that I can get my desired output using xlsxwriter? > > I had to simulate docx.api. With that caveat the following seems to work: > > import xlsxwriter > > # begin simulation of > # from docx.api import Document > > class Cell: > def __init__(self, text): > self.text = text > > class Row: > def __init__(self, cells): > self.cells = [Cell(c) for c in cells] > > class Table: > def __init__(self, data): > self.rows = [ > Row(row) for row in data > ] > > class Document: > def __init__(self): > self.tables = [ > Table([ > ["Hello", "Test"], > ["est", "ing"], > ["gg", "ff"] > ]), > Table([ > ["Foo", "Bar", "Baz"], > ["ham", "spam", "jam"] > ]) > ] > > document = Document() > > # end simulation > > wb = xlsxwriter.Workbook("tmp.xlsx") > sheet = wb.add_worksheet("Compliance") > > offset = 0 > for table in document.tables: > for y, row in enumerate(table.rows): > for x, cell in enumerate(row.cells): > sheet.write(y + offset, x, cell.text) > offset += len(table.rows) + 1 # one empty row between tables > > wb.close() Hi Peter, thank you for your efforts :) However, what if there are many tables in the word document, it would be tedious to have to code the texts in the tables one by one. Can I instead, call on the word document and let Python do the parsing for tables and its contents?

2 1

Re: Behaviour of os.path.join
by BlindAnagram May 27, 2020

May 27, 2020

On 27/05/2020 16:49, Rhodri James wrote: > On 27/05/2020 16:12, BlindAnagram wrote: >> I'm sorry that you don't believe me but all I know is how I intend the >> path to be used. And the os.path functions aren't helpful here when >> they actually_change_ the meanings of paths on Windows: >> >>>> fp= "C:\\Documents\finance\\" >>>> abspath(fp) >> 'C:\\Documents\\finance' >> >> If you believe these 'before' and 'after' paths are the same I can only >> assume that you don't work on Windows (where one refers to a directory >> and the other a file without an extension). > > More accurately, one is not a legal filename but both are legal > directory names. If they are to be created, which is my situation, the result will be a diretory and a file. > I entirely believe that you have a problem, but I'm inclined to think > it's of your own making. You seem to have decided how paths work > without checking whether the language agrees with you. It doesn't, and > hasn't for over a decade without a significant number of complaints (as > in I can't remember the last one, and I've been around here for a while > -- it's too hot for me to want to go hunt in the archives :-). Why do you believe my understanding of Python is lacking? It seems to me that I have tried to avoid this very issue by explicitly sending a directory and I have been thwarted by a combination of poor knowledge elsewhere and a poorly designed function that changes the semantics of what it is offered. I would be surprised if issues such as these were not, at least in significant part, the reason why we now have pathlib. > How are these unexpected extensionless files getting created? I believe by attempting to make the directory I send absolute with abspath() and then copying a file to this path. They expected this to copy the file into the directory with its original name but instead it copies it to the file that abspath 'kindly' converts my directory into. I did complain about their lack of knowledge but I also have a right to complain about a function that converts an explicitly specified directory into a file :-)

3 2

Write tables from Word (.docx) to Excel (.xlsx) using xlsxwriter
by BBT May 27, 2020

May 27, 2020

I am trying to parse a word (.docx) for tables, then copy these tables over to excel using xlsxwriter. This is my code: from docx.api import Document import xlsxwriter document = Document('/Users/xxx/Documents/xxx/Clauses Sample - Copy v1 - for merge.docx') tables = document.tables wb = xlsxwriter.Workbook('C:/Users/xxx/Documents/xxx/test clause retrieval.xlsx') Sheet1 = wb.add_worksheet("Compliance") index_row = 0 print(len(tables)) for table in document.tables: data = [] keys = None for i, row in enumerate(table.rows): text = (cell.text for cell in row.cells) if i == 0: keys = tuple(text) continue row_data = dict(zip(keys, text)) data.append(row_data) #print (data) #big_data.append(data) Sheet1.write(index_row,0, str(row_data)) index_row = index_row + 1 print(row_data) wb.close() This is my desired output: https://i.stack.imgur.com/9qnbw.png However, here is my actual output: https://i.stack.imgur.com/vpXej.png I am aware that my current output produces a list of string instead. Is there anyway that I can get my desired output using xlsxwriter?

2 1

Re: Behaviour of os.path.join
by BlindAnagram May 27, 2020

May 27, 2020

On 27/05/2020 14:53, Rhodri James wrote: > On 27/05/2020 14:41, BlindAnagram wrote: >> That is true if you know for sure how your path will be used. >> >> But if you don't, there is a world of difference between passing the >> paths 'name' and 'name\\' on for others to use. And in this situation it >> doesn't help when os.path functions strip the directory separator off. > > Only if you impose meaning externally, which implies you do know how > your path will be used after all. If you want to know whether a given > path corresponds to a file or a directory on a filing system, there's no > real substitute for looking on the filing system. Anything else is, as > you have discovered, error-prone. I'm sorry that you don't believe me but all I know is how I intend the path to be used. And the os.path functions aren't helpful here when they actually _change_ the meanings of paths on Windows: >> fp= "C:\\Documents\finance\\" >> abspath(fp) 'C:\\Documents\\finance' If you believe these 'before' and 'after' paths are the same I can only assume that you don't work on Windows (where one refers to a directory and the other a file without an extension).

2 1