#!/usr/bin/env python
# coding:utf8
import urllib
import csv
url = 'https://aviationweather.gov/adds/dataserver_current/current/metars.cache.csv'
urllib.urlretrieve(url, filename='metar.csv')
file = open('metar.csv').readlines()
for f in file:
	s = f.split(',')
	print s[1]

 # coding:utf-8
import urllib
import gzip
from time import time
from PyQt4.Qt import *
def get_gz(gz_name):
    out = []
    with gzip.open(gz_name,'rb') as gz:
        lines = gz.readlines()
        for line in lines:
            out.append(line.split(','))
    return out
class Table(QTableWidget):
    def __init__(self):
        QTableWidget.__init__(self)
        self.setFont(QFont("times",14))
    def setData(self,table):
        cols = len(table[0])
        rows = len(table)
        self.setRowCount(rows)
        self.setColumnCount(cols)
        for i in xrange(rows):
            for j in xrange(cols):
                item = QTableWidgetItem()
                item.setText(table[i][j])
                self.setItem(i,j,item)
    def setHeaders(self,lst):
        out = []
        for x,i in enumerate(lst):
            out.append(str(x) + "\n" + i.strip())
        self.setHorizontalHeaderLabels(out)
        self.resizeColumnsToContents()
if __name__ == "__main__":
    app = QApplication([])
    t1 = time()
    url = 'https://aviationweather.gov/adds/dataserver_current/current/metars.cache.csv.gz'
    urllib.urlretrieve(url,filename='metar.csv.gz')
    t2 = time()
    table = get_gz('metar.csv.gz')
    t = Table()
    t.setData(table[6:])
    t.setHeaders(table[5])
    t.setColumnHidden(0,True)
    t.resize(900,600)
    t.move(0,0)
    t.show()
    t3 = time()
    print t2 - t1,t3 - t2,' '.join(table[4]),
    app.exec_()