calc_expend.py

#! /usr/bin/env python
# -*- coding: utf-8 -*-
# vim:fenc=utf-8
#
# Copyright © 2020 qiang.zhou <qiang.zhou@Macbook>
#
# Distributed under terms of the MIT license.

"""
Calcuate the expenses on my own records.
"""

import sys
import os

TMP_FILE = "/tmp/payoff-temp.log"

cmd = "pbpaste > {}".format(TMP_FILE)
os.system(cmd)

with open(TMP_FILE, "r") as f:
    data = f.read()

# Replace '，' to ',', remove blanks
data = data.replace('，', ',').replace(' ', '')
print ("Verbose the content in clipboard...")
print (data)

data_list = data.split('\n')

total_list = []
for item in data_list:
    if ',' in item:
        subpay = item.split(',')[-1]
    else:
        continue
    subpay = float(subpay)
    total_list.append(subpay)

total = sum(total_list)

print ("Total expend: {}".format(total))
print ("Max/Other: {}/{}".format(min(total_list), total-min(total_list)))