convert text file data to HTML table in python

[Tirumal]

Hi All,


i am using python 2.7.

i want convert  the text data to  HTML  table.

Below is my data ,please can you help me to convert the  below data  to HTML table?

No Name
10 Administration
20 Marketing
30 Purchasing
40 Human Resources
50 Shipping
60 IT
70 Public Relations
80 Sales
90 Executive
100 Finance
110 Accounting
120 Treasury
130 Corporate Tax
140 Control And Credit
150 Shareholder Services
160 Benefits
170 Manufacturing
180 Construction
190 Contracting
200 Operations
210 IT Support

Thanks
TR

[buran]

what have you tried? please post your code in code tags, full traceback in error tags (if you get any) and ask specific questions.
We are glad to help, but we are not doing our work for you.

[Tirumal]

Hi ,

I am using below code 

contents = open("D:\Projects\Automations\dbresult.txt","r")
with open("D:\Projects\Automations\dbresult.html", "w") as e:
    e.write("<table>\n")   
    for lines in contents.readlines():
        e.write("<tr><td>%s</td><td>%s</td></tr>\n"%lines.split())
    e.write("</table>\n")

Getting following  TypeError: not enough arguments for format string error

Thanks

[buran]

you are using old-style formatting and according to docs (https://docs.python.org/2/library/stdtyp...formatting):

If format requires a single argument, values may be a single non-tuple object. [5] Otherwise, values must be a tuple with exactly the number of items specified by the format string, or a single mapping object (for example, a dictionary).

in your case lines.split() returns list, not tuple and you get the above error. You need to convert lines.split() to tuple if you want to use old-style string formatting. Much better would be to use new-style - i.e. .format() method.

Also note that you have names with space in it, e.g. IT support
Just using split will yield unexpected result/rise error.

I suggest you try to amend your code and if you not succeed I will give additional hints.

[nilamo]

e.write("<tr><td>%s</td><td>%s</td></tr>\n"%lines.split())

Error:
 [b]TypeError: not enough arguments for format string[/b] error 

Seems like that's all the help you need :)
Your string has two format specifiers, but your lines.split() has more (or less) than two items.

[buran]

Your string has two format specifiers, but your lines.split() has more (or less) than two items.

no, it rise the error on the first line because it expects tuple, single argument or dict.
later on when there are more than 2 elements (given you supply tuple) it rise different error - TypeError: not all arguments converted during string formatting