Building Software II: HTML Table from .csv file and Sorting with Python

: My Concept :
1. Import file in Local Directory
2. Split and Collect in each variables for showing in HTML table
3. User can choose menu , How to sorting? (by Number or By Student ID)
4. Show HTML table

-สามารถเลือกได้ว่า ต้องการให้โชว์ตารางการจัดเรียงแบบไหน (มีให้เลือก by Number,by Student ID)

Result

Show Only

Show Only: Source Code

#!/usr/bin/env python
#---coding: utf-8 ---
print "Content-type:text/html\n ; charset=utf-8"

import csv,cgi,operator,collections

No = []
StdID = []
Name = []
Surname = []
BlogURL = []

dir_temp = ""

print """
<p>
<center>
Table HTML</center>
</p>
"""

with open('/home/watsize/A/cgi-bin/Liststudent.csv') as csvfile: 
 for row in csvfile:
  row = row.strip()
  words = row.split(",")
  No.append(words[0])
  StdID.append(words[1])
  Name.append(words[2])
  Surname.append(words[3])
  BlogURL.append(words[4])

##--Print area----------------------------------------------------------------------
dir_temp += '<table summary="CSV to Output" border="1" align="center">\n'
for index in range (0,len(No)): 
 dir_temp +='
<tr> <td>'+ No[index] +'</td><td>'+ StdID[index] + '</td><td>'+ Name[index] +'</td><td>' + Surname[index] + '</td><td>' + BlogURL[index] + '</td> </tr>
'
dir_temp += '</table>
\n'
##--Print Area----------------------------------------------------------------------

print dir_temp  <br>

---------------------------------------

Show and Menu :

Show and Menu : Source Code

#!/usr/bin/env python
#---coding: utf-8 ---
print "Content-type:text/html\n ; charset=utf-8"

import csv,cgi,operator,collections

No = []
StdID = []
Name = []
Surname = []
BlogURL = []

dir_temp = ""

print """

<p>
<center>
Table HTML</center>
</p>
<p>
<center>
ทดสอบ ภาษาไทย ด้วย UTF-8</center>
</p>
<form action="/cgi-bin/csvreader.cgi" method="get">
<p>
Selector : </p>
<p>
<input type="radio" name="sort" value="noMin" >No. [Min -> Max]
<br>
<input type="radio" name="sort" value="noMax" >No. [Max -> Min]
<br>
<input type="radio" name="sort" value="stdid">Student ID
<br>
<input type="submit" value="Submit"/>
</form>
"""

##---Selection Area---
selected = cgi.FieldStorage() 
sort_option = selected.getvalue('sort')
sort_name ='Select : '
NoI = {}
StdIDI = {}
StdIDVal = {}
Option = ""
A_Stdnumber = []

if sort_option == 'noMax' :
 sort_name += "Number Max -> Min"
 for itoint in range (1,len(No)):
  if No[itoint] =='':
   continue
  else:
   NoI[itoint-1] = int(No[itoint])
 NoI = sorted(NoI,reverse = True)
 Option = NoI

elif sort_option == 'stdid':
 sort_name += "Student ID"
 for itoint in range (1,len(StdID)):
  if StdID[itoint] =='':
   continue
  else:
   StdIDI[itoint] = int(StdID[itoint])
 StdIDVal = StdIDI.values() 
 StdIDI = sorted(StdIDI.values())
 
 for i in range (0,len(StdIDI)):
  A_Stdnumber.append(int(StdIDVal.index(StdIDI[i]))+1)
 Option = A_Stdnumber

else:
 sort_name += "Number Min -> Max"
 for itoint in range (1,len(No)):
  if No[itoint] =='':
   continue
  else:
   NoI[itoint-1] = int(No[itoint])
 NoI = sorted(NoI)
 Option = NoI

print sort_name + "<br><br>"
##---Selection Area---

##--Print area----------------------------------------------------------------------
dir_temp += '<table summary="CSV to Output" border="1" align="center">\n'
for index in Option:
 dir_temp +='
<tr> <td>'+ No[index] +'</td><td>'+ StdID[index] + '</td><td>'+ Name[index] +'</td><td>' + Surname[index] + '</td><td>' + BlogURL[index] + '</td> </tr>
'
dir_temp += '</table>
\n'
##--Print Area----------------------------------------------------------------------

print dir_temp

Extend Link :
https://docs.python.org/2/library/functions.html
https://docs.python.org/2/tutorial/datastructures.html#more-on-lists
http://www.tutorialspoint.com/python/list_index.htm
http://stackoverflow.com/questions/1217251/python-sorting-a-dictionary-of-lists

and Tag for Google : List , Dictionary , csv in python , UTF-8 , Radio Button , Sorting , HTML Table , HTML Tag

Building Software II

วันพฤหัสบดีที่ 22 มกราคม พ.ศ. 2558

HTML Table from .csv file and Sorting with Python

ไม่มีความคิดเห็น:

แสดงความคิดเห็น

จำนวนการดูหน้าเว็บรวม

ป้ายกำกับ

คลังบทความของบล็อก