import pandas as pd
import numpy as np

#plt.ylabel("Total Number of Occurrences")
#plt.xlabel("Rank of word")
#plt.show()

data = pd.read_csv('fifaa.csv', encoding = "ISO-8859-1")
#print(data["Wage"])

def convert_currency(curr_col):
    without_euro_symbol = curr_col.str[1:]
    num = without_euro_symbol.str[:-1]

    number = pd.to_numeric(num, errors='coerce').fillna(0, downcast='infer')

    unit_symbol = without_euro_symbol.str[-1]
    
    multipliers = unit_symbol.replace({'M': 1e6, 'K': 1e3})
    
    print(number * multipliers)
    return number * multipliers

data["Wage"] = convert_currency(data["Wage"])
data["Value"] = convert_currency(data["Value"])

#print(data["Wage"])