Production

View or edit on GitHub

This page is synchronized from trase/models/indonesia/shrimp/Production.ipynb. Last modified on 2025-12-14 23:19 CET by Trase Admin. Please view or edit the original file there; changes should be reflected here after a midnight build (CET time), or manually triggering it with a GitHub action (link).

import pandas as pd
from trase.tools.pcs import *

for year in range(2015, 2019):
    df = pd.read_csv(f"{year}/prepared/production.csv", sep=";")
    df["province"] = df["province"].apply(
        lambda x: get_trase_id(
            check_region(x, "PROVINCE", parent_id=get_country_id("INDONESIA"))
        )
    )
    df.to_csv(f"INDONESIA_SHRIMP_PRODUCTION_DOWNSCALED_{year}.csv", index=False)
    df = df.groupby("province")["volume_raw"].sum().reset_index()
    df["year"] = year
    df.to_csv(f"INDONESIA_SHRIMP_PROVINCE_PRODUCTION_{year}.csv", index=False)
    print(year)
    print(df["volume_raw"].sum())