<jupyter_start><jupyter_text>Total renewable surface water (TRSW)<jupyter_code>get_TRSW = """
Select Year, AreaId, Area, Value FROM parameter
where VariableId = 4185
ORDER by Area
"""

df_TRSW = pd.read_sql(sql=get_TRSW, con=conn)
df_TRSW[:20]
# TRSW is static!!! except Bhutan...
df_TRSW.drop_duplicates(subset ="Value", 
                     keep = "first", inplace = True) 
temp = df_TRSW.groupby("Area").count()[['Value']]
temp.loc[temp['Value'] != 1]<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.15670103092783505, 'fraction_numerical': 0.01443298969072165, 'mean_word_length': 5.151898734177215, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '258933', 'license': 'MIT', 'n_tokens_mistral': 188, 'n_tokens_neox': 178, 'n_words': 37, 'path': 'data/Forecast/Prediction_modeling.ipynb', 'repo_name': 'afreeorange/CSE6242-Project', 'size': '485'}