Batch update to a File Column

Platform discussions
,
1

Does anyone have a solution to this one !

I have a file column with a jpg image that has been imported via Zapier without a file extension. I need to add a jpeg file extension to all of the items (circa 3000). Does anyone know I could do this ?

Many thanks
Antony

2

Hi Antony
there is easy way to do this, you could use a scripting language like Python to automate this task. You would read the file, iterate through each item in the column, add the “.jpeg” extension to it, and then save the changes back to the file.

import pandas as pd

# Read the file
df = pd.read_csv('your_file.csv')

# Add '.jpeg' extension to each item in the column
df['column_name'] = df['column_name'].astype(str) + '.jpeg'

# Save the changes back to the file
df.to_csv('your_file_with_extension.csv', index=False)

this will help you to image import via Zapier