import pandas as pd

# Load the dataframe.
df = pd.read_csv('Use this old data below and work out the inCircul....xlsx - Use this old data below and wor.csv')

# Make a copy of the DataFrame to avoid a SettingWithCopyWarning during the cleaning process.
df_clean = df.copy()

# Clean the 'Difference' column.
df_clean['Difference'] = df_clean['Difference'].astype(str).str.replace(r'[\+,]', '', regex=True)
df_clean['Difference'] = pd.to_numeric(df_clean['Difference'], errors='coerce')

# Function to format the output string with the new date.
def format_item(row):
    item_name = row['Item']
    in_circulation = row["New 'In Circulation'"]
    difference = row['Difference']
    status = 'higher' if difference > 0 else 'lower'
    return f"{item_name}: In Circulation: {in_circulation}, Difference from 07/2025: {difference} ({status})"

# Apply the function to each row and create a list of formatted strings.
formatted_list = df_clean.apply(format_item, axis=1).tolist()

# Join the list into a single string with newlines for easy copy-pasting.
formatted_output = "\n".join(formatted_list)

# Print the final formatted output.
print(formatted_output)

Traceback (most recent call last):
  File "<string>", line 8
    in_circulation = data_row['New 'In Circulation'']
                              ^^^^^^^^
SyntaxError: invalid syntax. Perhaps you forgot a comma?

import pandas as pd

# Load the dataframe.
df = pd.read_csv('Use this old data below and work out the inCircul....xlsx - Use this old data below and wor.csv')

# Make a copy of the DataFrame to avoid a SettingWithCopyWarning during the cleaning process.
df_clean = df.copy()

# Clean the 'Difference' column.
df_clean['Difference'] = df_clean['Difference'].astype(str).str.replace(r'[\+,]', '', regex=True)
df_clean['Difference'] = pd.to_numeric(df_clean['Difference'], errors='coerce')

# Function to format the output string.
def format_item(row):
    item_name = row['Item']
    in_circulation = row["New 'In Circulation'"]
    difference = row['Difference']
    status = 'higher' if difference > 0 else 'lower'
    return f"{item_name}: In Circulation: {in_circulation}, Difference from 07/2025: {difference} ({status})"

# Apply the function to each row and create a list of formatted strings.
formatted_list = df_clean.apply(format_item, axis=1).tolist()

# Join the list into a single string with newlines for easy copy-pasting.
formatted_output = "\n".join(formatted_list)

# Print the final formatted output.
print(formatted_output)

Mini-Supporter Pack: In Circulation: 19139, Difference from 07/2025: 37 (higher)
Supporter Pack: In Circulation: 2068, Difference from 07/2025: 23 (higher)
Personal Favour: In Circulation: 24887, Difference from 07/2025: 1250 (higher)
Corana Beer: In Circulation: 113819, Difference from 07/2025: 15208 (higher)
Mexcal Beer: In Circulation: 35812, Difference from 07/2025: 4346 (higher)
Blancoda Tequila: In Circulation: 84914, Difference from 07/2025: 14247 (higher)
Repose Tequila: In Circulation: 40390, Difference from 07/2025: 5932 (higher)
Anejo Tequila: In Circulation: 21474, Difference from 07/2025: 2611 (higher)
Raicilla: In Circulation: 9965, Difference from 07/2025: 1839 (higher)
Bandage: In Circulation: 933974, Difference from 07/2025: 87801 (higher)
Small Medical Kit: In Circulation: 585947, Difference from 07/2025: 52116 (higher)
Large Medical Kit: In Circulation: 249133, Difference from 07/2025: 21322 (higher)
Basic Trauma Kit: In Circulation: 103292, Difference from 07/2025: 8600 (higher)
Large Trauma Kit: In Circulation: 61359, Difference from 07/2025: 5346 (higher)
Tainted Cocaine: In Circulation: 147859, Difference from 07/2025: 11709 (higher)
Tainted Cannabis: In Circulation: 209108, Difference from 07/2025: 8313 (higher)
Cannabis: In Circulation: 1310345, Difference from 07/2025: 117161 (higher)
Cocaine: In Circulation: 197527, Difference from 07/2025: 20374 (higher)
Bag of Fertiliser: In Circulation: 456568, Difference from 07/2025: 90435 (higher)
Agave Heart: In Circulation: 391068, Difference from 07/2025: 108220 (higher)
Coca Paste: In Circulation: 821502, Difference from 07/2025: 129296 (higher)
Dog Food: In Circulation: 109994, Difference from 07/2025: 3118 (higher)
Black Market Treat: In Circulation: 2588, Difference from 07/2025: 66 (higher)
Velvet Mystery Gift: In Circulation: 7735, Difference from 07/2025: -77 (lower)
Green Surprise Gift: In Circulation: 1621, Difference from 07/2025: -16 (lower)
Glittering Gift: In Circulation: 1408, Difference from 07/2025: -14 (lower)
Rustic Charm Gift: In Circulation: 1009, Difference from 07/2025: -2 (lower)
Golden Treasure Gift: In Circulation: 319, Difference from 07/2025: -2 (lower)
AK-47: In Circulation: 3551, Difference from 07/2025: 150 (higher)
M16A2 Rifle: In Circulation: 4361, Difference from 07/2025: 131 (higher)
G36: In Circulation: 879, Difference from 07/2025: 36 (higher)
Steyr AUG: In Circulation: 486, Difference from 07/2025: 34 (higher)
SIG SG 550: In Circulation: 13, Difference from 07/2025: 1 (higher)
FN SCAR-H: In Circulation: 1045, Difference from 07/2025: 96 (higher)
Baseball Bat: In Circulation: 20440, Difference from 07/2025: 1334 (higher)
Walther P38: In Circulation: 20417, Difference from 07/2025: 897 (higher)
M1911: In Circulation: 2943, Difference from 07/2025: 124 (higher)
S&W Magnum Revolver: In Circulation: 1251, Difference from 07/2025: 7 (higher)
Glock 18: In Circulation: 1282, Difference from 07/2025: 41 (higher)
Desert Eagle: In Circulation: 287, Difference from 07/2025: 15 (higher)
Bazooka: In Circulation: 72, Difference from 07/2025: -3 (lower)
Covert Stab Vest: In Circulation: 17290, Difference from 07/2025: 378 (higher)
Ballistic Vest: In Circulation: 8352, Difference from 07/2025: -84 (lower)
Tactical Plate Armour: In Circulation: 1010, Difference from 07/2025: 36 (higher)
Full-Body Armour: In Circulation: 2204, Difference from 07/2025: 283 (higher)
Trench Coat: In Circulation: 14101, Difference from 07/2025: 37 (higher)
Kevlar Weave Vest: In Circulation: 3871, Difference from 07/2025: -5 (lower)
Carbon Fiber Vest: In Circulation: 134, Difference from 07/2025: -1 (lower)
Armoured Suit: In Circulation: 3148, Difference from 07/2025: 87 (higher)
Ceramic Plate Carrier Vest: In Circulation: 2544, Difference from 07/2025: -47 (lower)
Riot Suit: In Circulation: 3360, Difference from 07/2025: 9 (higher)
Blast Suit: In Circulation: 725, Difference from 07/2025: -5 (lower)
New-Age Combat Fatigues: In Circulation: 679, Difference from 07/2025: 4 (higher)
MG34: In Circulation: 1340, Difference from 07/2025: 96 (higher)
L86 LSW: In Circulation: 225, Difference from 07/2025: 6 (higher)
MG5: In Circulation: 186, Difference from 07/2025: 41 (higher)
Fragmentation Grenade: In Circulation: 41652, Difference from 07/2025: 4062 (higher)
Flash Bang Grenade: In Circulation: 38864, Difference from 07/2025: 3152 (higher)
Illuminating Grenade: In Circulation: 30008, Difference from 07/2025: 2828 (higher)
Tear Gas Grenade: In Circulation: 30174, Difference from 07/2025: 3380 (higher)
Stun Grenade: In Circulation: 36854, Difference from 07/2025: 2641 (higher)
Nails: In Circulation: 257504, Difference from 07/2025: 13824 (higher)
Bricks: In Circulation: 251816, Difference from 07/2025: 10094 (higher)
Concrete Bags: In Circulation: 171401, Difference from 07/2025: 6172 (higher)
Steel: In Circulation: 89550, Difference from 07/2025: 4392 (higher)
Renault Espace: In Circulation: 18916, Difference from 07/2025: 660 (higher)
Fiat Panda: In Circulation: 16567, Difference from 07/2025: 560 (higher)
Austin Metro: In Circulation: 8081, Difference from 07/2025: 239 (higher)
Peugeot 205 GTI: In Circulation: 5875, Difference from 07/2025: 210 (higher)
Ford Sierra: In Circulation: 7002, Difference from 07/2025: 446 (higher)
Vauxhall Cavalier: In Circulation: 5171, Difference from 07/2025: 395 (higher)
Ford *: In Circulation: 4099, Difference from 07/2025: 0 (lower)
Honda CRX: In Circulation: 2750, Difference from 07/2025: -74 (lower)
Saab 900 Turbo: In Circulation: 2639, Difference from 07/2025: 45 (higher)
Lancia Delta Integrale: In Circulation: 1671, Difference from 07/2025: 36 (higher)
Toyota MR2: In Circulation: 1969, Difference from 07/2025: 136 (higher)
Audi Quattro 1980: In Circulation: 1278, Difference from 07/2025: 96 (higher)
Ford Capri 2.8i: In Circulation: 1171, Difference from 07/2025: 69 (higher)
Volkswagen Golf GTI: In Circulation: 870, Difference from 07/2025: 87 (higher)
BMW M5: In Circulation: 1099, Difference from 07/2025: 122 (higher)
Porsche 959: In Circulation: 679, Difference from 07/2025: 87 (higher)
Ferrari F40: In Circulation: 2100, Difference from 07/2025: 277 (higher)
Lamborghini Countach: In Circulation: 1614, Difference from 07/2025: 275 (higher)
Diablo Tattoo: In Circulation: 22721, Difference from 07/2025: 174 (higher)
Italian Shoes: In Circulation: 17304, Difference from 07/2025: 89 (higher)
Cuban Cigar Set: In Circulation: 8875, Difference from 07/2025: 400 (higher)
Eagle Cabernet 1992: In Circulation: 5918, Difference from 07/2025: 215 (higher)
Whiskey Decanter: In Circulation: 6521, Difference from 07/2025: 283 (higher)
Gold Grooming Kit: In Circulation: 4880, Difference from 07/2025: 232 (higher)
Gemstone Cufflinks: In Circulation: 4007, Difference from 07/2025: 8 (higher)
Lapis-Encrusted Lighter: In Circulation: 2646, Difference from 07/2025: -81 (lower)
Satellite Phone: In Circulation: 2970, Difference from 07/2025: 252 (higher)
Club VIP Lounge Membership: In Circulation: 1968, Difference from 07/2025: 138 (higher)
Pearl-Encrusted Lighter: In Circulation: 1940, Difference from 07/2025: 153 (higher)
Diamond Watch: In Circulation: 1171, Difference from 07/2025: 58 (higher)
Diamond-Encrusted Lighter: In Circulation: 1133, Difference from 07/2025: 67 (higher)
Bulletproof Suit: In Circulation: 820, Difference from 07/2025: 66 (higher)
Pet Jaguar: In Circulation: 1106, Difference from 07/2025: 160 (higher)
Gold-Plated Pistol: In Circulation: 818, Difference from 07/2025: 134 (higher)
Platinum Credit Card: In Circulation: 2359, Difference from 07/2025: 344 (higher)
Personal Helicopter: In Circulation: 1590, Difference from 07/2025: 239 (higher)
El Chapo's Head: In Circulation: 59, Difference from 07/2025: 0 (lower)
Pablo's Hat: In Circulation: 1188, Difference from 07/2025: -4 (lower)
Quecheu Troll Doll: In Circulation: 3, Difference from 07/2025: 0 (lower)
The Easter Fuggly: In Circulation: 159, Difference from 07/2025: 0 (lower)
Elf on a Shelf - Green: In Circulation: 9548, Difference from 07/2025: -2 (lower)
Elf on a Shelf - Red: In Circulation: 9588, Difference from 07/2025: -4 (lower)
Padrino's Egg: In Circulation: 309, Difference from 07/2025: 0 (lower)
Street-Quality Enhancement: In Circulation: 28392, Difference from 07/2025: 21264 (higher)
Syndicate-Issued Enhancement: In Circulation: 11173, Difference from 07/2025: 9544 (higher)
Blacksite Prototype Enhancement: In Circulation: 3596, Difference from 07/2025: 2928 (higher)