打开远程文件

CSV文件处理

输出为excel - openxyl

# pandas - Get remote file
df = pandas.read_csv("<https://github.com/chris1610/pbpython/blob/master/data/sample-sales-tax.csv?raw=True>")
# pandas - do some calcs, [] inside a [] make it a list nor tuple
df_summary = df.groupby('category')[['ext price','Tax rate']].sum()

# openpyxl
# Return python envir path, PROJECT PATH
out_file_path = pathlib.Path.cwd() / "data" / "tax_summary.xlsx"
# Save the file as Excel
df_summary.to_excel(out_file_path)