Numeric column conversion for exported FM team data.

exclude_cols.py

# Create excluded columns
EXCLUDE_COLS = """Inf
Name
Apps
Best Pos
Best Role
Best Duty
Pros
Expires
Distance
Dist/90
Cons
Position
Club
On Loan From
Based
Asking Price
Salary
Nat
2nd Nat
Home Grown Status
Height
Weight
Preferred Foot
Personality
Media Handling
Shot %
Pas %
OP-Cr %
Conv %
Hdr %
xSv %
Sv %
Transfer Value
UID""".split("\n")
EXCLUDE_COLS

# Convert all the columns, barring exclusions to numeric
for col in scouting_data.columns:
    if col not in EXCLUDE_COLS:
        try:
            # print(f"Processing {col}")
            convert_to_numeric(scouting_data, scouting_data[col])
        except:
            pass