การอ่านไฟล์ .CSV และแสดงค่า

     ทำการอ่านไฟล์ .csv ที่ได้ save ไว้บนเครื่อง โดยเขียนภาษา python ให้นำข้อมูลในไฟล์ .csv มาแสดงแบบตาราง บน web ที่เปิดจาก ServerCGI

จากภาพจะมีไฟล์ .csv ที่saveไว้บนเครื่องและลองทดสอบ run code ผ่าน terminal

#!/usr/bin/env python #-*-coding: utf-8 -*- print "Content-type:text/html\n ; charset=utf-8" import csv number = [] studentid = [] name = [] surname = [] blog = [] print """ <p> <h1> <center> Show CSV FIle</center> </H1> </p> """ with open('/home/student/cgi-bin/list.csv') as csvfile: for row in csvfile: column = row.split(",") number.append(column[0]) studentid.append(column[1]) name.append(column[2]) surname.append(column[3]) blog.append(column[4]) print '<table BORDER = "2" align="center">' for i in range(0,len(number)): print " <tr><td>"+number[i]+"</TD><td>"+studentid[i]+"</TD><td>"+name[i]+"</TD><td>"+surname[i]+"</TD><td>"+blog[i]+"</TD></TR> \n" print "</Table>"


Code Min to Max by ID
#!/usr/bin/env python #-*-coding: utf-8 -*- print "Content-type:text/html\n ; charset=utf-8" import csv number = [] studentid = [] studentidnew = [] name = [] surname = [] blog = [] print """ <p> <h1> <center> Show CSV FIle</center> </H1> </p> """ with open('/home/teng/cgi-bin/list.csv') as csvfile: for row in csvfile: column = row.split(",") number.append(column[0]) studentid.append(column[1]) studentidnew.append(column[1]) name.append(column[2]) surname.append(column[3]) blog.append(column[4]) studentid.sort() print '<table BORDER = "2" align="center">' print " <tr><td>"+number[0]+"</TD><td>"+studentidnew[0]+"</TD><td>"+name[0]+"</TD><td>"+surname[0]+"</TD><td>"+blog[0]+"</TD></TR> \n" for i in range(0,len(number)-1): for j in range(0,len(number)): if studentid[i] == studentidnew[j]: print " <tr><td>"+number[j]+"</TD><td>"+studentidnew[j]+"</TD><td>"+name[j]+"</TD><td>"+surname[j]+"</TD><td>"+blog[j]+"</TD></TR> \n" print "</Table>"

Code Max to Min by ID
#!/usr/bin/env python #-*-coding: utf-8 -*- print "Content-type:text/html\n ; charset=utf-8" import csv number = [] studentid = [] studentidnew = [] name = [] surname = [] blog = [] print """ <p> <h1> <center> Show CSV FIle</center> </H1> </p> """ with open('/home/teng/cgi-bin/list.csv') as csvfile: for row in csvfile: column = row.split(",") number.append(column[0]) studentid.append(column[1]) studentidnew.append(column[1]) name.append(column[2]) surname.append(column[3]) blog.append(column[4]) studentid.sort(reverse=True) print '<table BORDER = "2" align="center">' print " <tr><td>"+number[0]+"</TD><td>"+studentidnew[0]+"</TD><td>"+name[0]+"</TD><td>"+surname[0]+"</TD><td>"+blog[0]+"</TD></TR> \n" for i in range(1,len(number)): for j in range(1,len(number)): if studentid[i] == studentidnew[j]: print " <tr><td>"+number[j]+"</TD><td>"+studentidnew[j]+"</TD><td>"+name[j]+"</TD><td>"+surname[j]+"</TD><td>"+blog[j]+"</TD></TR> \n" print "</Table>"

http://java.dzone.com/articles/python-101-reading-and-writing เว็บศึกษาการเปิด .csv
http://janphar.lpru.ac.th/wanasiri/htmltag.html สร้างตาราง
http://118.174.14.67/html/basichtml.html แสดงภาษาไทย