#!/usr/bin/env python # Wenchang Yang (wenchang@princeton.edu) # Mon Jul 12 15:13:32 EDT 2021 if __name__ == '__main__': from misc.timer import Timer tt = Timer(f'start {__file__}') import sys, os.path, os, glob, datetime #import xarray as xr, numpy as np, pandas as pd, matplotlib.pyplot as plt import pandas as pd #more imports # if __name__ == '__main__': tt.check('end import') # #start from here with open('index.html', 'w') as f: f.write('\n') f.write('\n') f.write('\n') f.write(f'2021 Pacific Northwest Heatwave\n') f.write('\n') f.write('\n') f.write('\n') f.write('\n') f.write('\n') f.write('\n') f.write('\n') f.write('
\n') # title section f.write(' \n') f.write('\n') #news list f.write('
\n') df = pd.read_excel('NA_heatwave_WWA_coverage.xls') cols = ['Date', 'Headline', 'URL', 'Source', 'Country'] ii = 1 for _,r in df.loc[:, cols].drop_duplicates().sort_values('Date').iterrows(): date, headline, url, source, country = r['Date'], r['Headline'], r['URL'], r['Source'], r['Country'] s = f"
  • [{ii:04d}] {date}: {headline}, {source}, {country}
  • \n" f.write(s) ii = ii + 1 f.write('
    \n') f.write('
    \n') f.write('\n') f.write('\n') if __name__ == '__main__': #from wyconfig import * #my plot settings #savefig if 'savefig' in sys.argv: figname = __file__.replace('.py', f'.png') wysavefig(figname) tt.check(f'**Done**') #plt.show()