Parsing CSV file name list into HTML list using Python

What Will I Learn?

This tutorial will teach you

• to read CSV files using CSV module.
• parse CSV file name list into HTML list

Requirements

• A PC/laptop with any Operating system such as Linux, Mac OSX, Windows OS
• Preinstalled Python
• Preinstalled Code Editors such as Atom, Sublime text or Pycharm IDE

Note: This tutorial is performed in Pycharm IDE in laptop with Ubuntu 17.1, 64 bit OS

Difficulty

Intermediate, anyone with a basic concept of CSV files and programming knowledge of python or any other programming language can catch up this tutorial. I recommend learning basics of python programming before starting this tutorial. The links for previous tutorials are at the bottom of this tutorial.

Tutorial Contents

We will start by importing CSV module of python.

import csv

Then, we will open existed csv file in reading mode. The csv file contains top six sponsors, delegated steem power and steem received data in table format separated by commas. The existed file to open is found here.

with open('sponsers.csv', 'r') as csvfile:

Now we will define variable csv_reader to hold returned object from csv.reader method and print the values of each lines in csv file using loop. Our final code looks like:

import csv
with open('sponsers.csv', 'r') as csvfile:
    csv_reader=csv.reader(csvfile)
    for line in csv_reader:
        print(line)

Output:

['Username', ' Delegated Steem Power', ' Steem Received']
['freedom', ' 1222997 SP', ' 10241.32']
['misterdelegation', ' 1019154 SP', ' no data']
['ned', ' 1010369 SP', ' no data']
['wackau', ' 97840 SP', ' 727.88']
['xeldal', ' 50791 SP', ' 431.22']
['lafona-miner', ' 24460 SP', ' 170.44']

The first line of the output is known as fieldnames if we map datas as dictionary.We don't want to print fieldnames in our output. So, we will add

next(csv_reader)

befor the loop to skip it while printing.

import csv
with open('sponsers.csv', 'r') as csvfile:
    csv_reader=csv.reader(csvfile)
    next(csv_reader)
    for line in csv_reader:
         print(line)

Output:

['freedom', ' 1222997 SP', ' 10241.32']
['misterdelegation', ' 1019154 SP', ' no data']
['ned', ' 1010369 SP', ' no data']
['wackau', ' 97840 SP', ' 727.88']
['xeldal', ' 50791 SP', ' 431.22']
['lafona-miner', ' 24460 SP', ' 170.44']

These are the top six sponsers of utopian.io. Now we will parse this csv file to html list.
For this, we need to define a variable after importing csv module which holds our HTML list.

html_list=''

Now, it is empty where data will be assigned later.
then, we will define empty list which holds usernames of sponsors, which is also assigned later.

sponsors=[]

To add a list of usernames in sponsors we assign the values of index [0] skipping the first row we edit above code to make look like below:

import csv
sponsers = []
with open('sponsers.csv', 'r') as csvfile:
    csv_reader=csv.reader(csvfile)
    next(csv_reader)
    for line in csv_reader:
        sponsers=line[0]
        print(sponsers)

Output:

freedom
misterdelegation
ned
wackau
xeldal
lafona-miner

Now, we will parse above usernames into HTML list. We will use DictReader method and f' string in this process. Dictreader is same like reader method of csv module. The only difference is Dictreader maps data into dictionary to perform operation. f' string is formatted string literals which also accepts replacement fields . The field to be replaced is surrounded by curly brackets.

import csv
html_list = ''
username = []
with open('sponsers.csv', 'r') as csvfile:
    csv_reader = csv.DictReader(csvfile)
    html_list += f'<p>HTML list of top six sponsers </p>'
    html_list += '\n<ul>'
    for line in csv_reader:
      username=line['Username']
      html_list += f'\n\t<li>{username}</li>'
    html_list += '\n</ul>'
print(html_list)

In above code, only username field is taken and added to html list. The usernames are looped and replaced each time in {username} and gets printed.

Output:

<p>HTML list of top six sponsers </p>
<ul>
    <li>freedom</li>
    <li>misterdelegation</li>
    <li>ned</li>
    <li>wackau</li>
    <li>xeldal</li>
    <li>lafona-miner</li>
</ul>

Ok now we learned to parse csv file field into html list , this script will automate the process and saves alot of time in future.
all above codes including previous tutorials codes are available in my Github repo. Click here to download

For more details please visit Python Docs.

Curriculum

Python tutorials for beginners : Part - I

Python tutorials for beginners : Part - II

Python tutorials for beginners : Part - III

Object-oriented Python

Reading and writing to files in python

---

Posted on Utopian.io - Rewarding Open Source Contributors

---