从dataframe中删除列中的某些特定关键字，并将其保存到json

import pandas as pd
import json

data = {'col1': ['apple', 'banana', 'orange'],
        'col2': ['cat', 'dog', 'elephant'],
        'col3': ['apple pie', 'banana bread', 'orange juice']}
df = pd.DataFrame(data)

keywords_to_remove = ['apple', 'banana']

df = df.apply(lambda x: x.str.replace('|'.join(keywords_to_remove), ''))

df.to_json('output.json', orient='records')

import pandas as pd
import json

data = {'col1': ['apple', 'banana', 'orange'],
        'col2': ['cat', 'dog', 'elephant'],
        'col3': ['apple pie', 'banana bread', 'orange juice']}
df = pd.DataFrame(data)

keywords_to_remove = ['apple', 'banana']

df = df.apply(lambda x: x.str.replace('|'.join(keywords_to_remove), ''))

df.to_json('output.json', orient='records')