Separate GCP billing by project

classify_gcp_payments.rb

require 'rake'
require 'csv'

#
# Usage:
#
# Need files(.csv) in same folder "junk".
#
# $ ruby junk/classify_gcp_payments.rb project-name
#

project = ARGV[0]
p project

file_list = FileList.new('junk/account_activities_*.csv')
regexp_filename = /^junk\/account_activities_(.*)\.csv$/

csv_opt = {
  headers: true,
  return_headers: false
}

results = {}

file_list.each do |filename|
  term = regexp_filename.match(filename).to_a[1] # filename から YYYYMM を取得
  amounts = []

  CSV.foreach(filename, "r:bom|utf-8") do |row|
    next unless row[0] == 'COSTS'
    next unless row[1].include? project
    amounts << row[2].to_f
  end

  results[term] = amounts.inject(:+).round(2)
end

p results.keys
p results.values

console.cloud.google.com/billing からダウンロードした CSV ファイルから、特定の project の料金だけ集計したいやつ

表示によってエクスポートできるCSV形式がことなるので注意 😱