read csv file into python dictionary and create html tables

Question

im a beginner in python and im trying to read a csv file into a python dictionary to generate html tables. i have 30 columns in my file and i want first 4 columns in csv file into my html table as columns and next six columns in another html table and so on..some of my columns includes strings and some includes integers csv file is like:

oposition mat won lost total overs
aa        5   3   2    400   20
bb        4   2   2    300   20
cc        4   3   1    100   19

im trying to get the data as :

<table>
<tr><td>aa</td> <td>5</td> <td>3</td> <td>2</td></tr>
<tr><td>bb</td> <td>4</td> <td>2</td> <td>2</td></tr>
<tr><td>cc</td> <td>4</td> <td>3</td> <td>1</td></tr>
</table>

so far my codes are;

infile = open("minew.csv", "r")
mydict = {}
for line in infile:
    words = line.split(",") 
    oposition = words[0]
    mat = words[1]
    won = words[2]
    lost = words[3]
    mydict[oposition] = oposition
    mydict[mat] = int(mat)
    mydict[won] = int(won)
    mydict[lost] = int(lost)

print("<table>")
for o,m,w,l in mydict.keys():
    print("<tr><td>{op}</td> <td>{mt}</td> <td>{wi}</td> <td>{lo}</td>
    </tr>".format(
        op = mydict[oposition],
        mt = mydict[mat]
        wi = mydict[won]
        lo = mydict[lost]))
print("</table>")

i cant make my codes working. please anyone help me out. much appreciated

What is it currently outputting? Please add that to the question. — TTeeple
– TTeeple, Commented May 25, 2017 at 13:09

Bartek Jablonski · Accepted Answer · 2017-05-25 13:15:06Z

4

Don't reinvent the wheel, use existing csv package:

import csv
with open('minew.csv') as csvfile:
     reader = csv.DictReader(csvfile, delimiter='\t')
     for row in reader:
         print('<tr>')
         for fn in reader.fieldnames:
             print('<td>{}</td>'.format(row[fn]))
         print('</tr>')

answered May 25, 2017 at 13:15

Bartek Jablonski

2,77524 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bill Bell · Accepted Answer · 2017-05-25 13:29:01Z

1

It wasn't clear to me that there is only a single character between the columns in your input file, such as a tab ('\t`), in which case I think the csv module might not be applicable. Here's another way of doing it.

print ('<table>')
with open('minew.csv') as minew:
    first = True
    for line in minew.readlines():
        if first:
            first = False
        else:
            values = line.split()
            print ('<tr>', end='')
            for value in values:
                print ('<td>%s</td>' % value, end='')
            print ('</tr>')
print ('</table>')

I think the principal difference between this and your code is that I've used split() instead of split(',') because there is whitespace between the columns.

This is the output.

<table>
<tr><td>aa</td><td>5</td><td>3</td><td>2</td></tr>
<tr><td>bb</td><td>4</td><td>2</td><td>2</td></tr>
<tr><td>cc</td><td>4</td><td>3</td><td>1</td></tr>
</table>

answered May 25, 2017 at 13:29

Bill Bell

21.7k6 gold badges48 silver badges62 bronze badges

2 Comments

Dush Over a year ago

changed the code and my csv file a bit and this works. im thinking of creating a html page and put this table inside that page. so instead of printing the data i tried to assign the same output into a new variable but my codes are going nowhere so far. is that possible to put the output into a html page editor code list or im thinking of copy and paste the output data into my html page editor. please help me out

Bill Bell Over a year ago

What kind of a variable do you want the output to go into? A string, list of strings? Something else? I'll help if I can.

Tiny.D · Accepted Answer · 2017-05-26 06:35:57Z

0

I think there are some points you'd better know:

1, you have to skip the header with next() when you open the csv file

2, No need to create a new dict to do that, and keep in mind python dict is not ordered.

3, Just use the element in the first loop, as you have already catch them.

4, Close the file after the operation is always a good practice.

Suppose you have csv file:

oposition mat won lost total overs
aa        5   3   2    400   20
bb        4   2   2    300   20
cc        4   3   1    100   19

Based on your logic, code goes here:

infile = open("minew.csv", "r")
next(infile)
print("<table>")
for line in infile:
    words = line.strip().split() 
    oposition = words[0]
    mat = words[1]
    won = words[2]
    lost = words[3]
    print("<tr><td>{op}</td> <td>{mt}</td> <td>{wi}</td> <td>{lo}</td></tr>".format(op = oposition,mt = mat,wi = won,lo = lost))
print("</table>")
infile.close()

Output:

<table>
<tr><td>aa</td> <td>5</td> <td>3</td> <td>2</td></tr>
<tr><td>bb</td> <td>4</td> <td>2</td> <td>2</td></tr>
<tr><td>cc</td> <td>4</td> <td>3</td> <td>1</td></tr>
</table>

edited May 26, 2017 at 6:35

answered May 25, 2017 at 13:35

Tiny.D

6,5562 gold badges18 silver badges20 bronze badges

4 Comments

Dush Over a year ago

IndexError: list index out of range

Tiny.D Over a year ago

is your csv file format same as the one in my answer?

Dush Over a year ago

IndexError Traceback (most recent call last) <ipython-input-12-462acbf24868> in <module>() 5 words = line.strip().split(",") 6 oposition = words[0] ----> 7 mat = words[1] 8 won = words[2] 9 lost = words[3] IndexError: list index out of range

Tiny.D Over a year ago

@Dush please check my updated answer, I have noted your csv file delimiter is space, then just change words = line.strip().split(",") to words = line.strip().split()

Collectives™ on Stack Overflow

read csv file into python dictionary and create html tables

3 Answers 3

Comments

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related