1,035
edits
No edit summary |
No edit summary |
||
Line 27: | Line 27: | ||
# sort values so that entries with reasons come first, dedupe | # sort values so that entries with reasons come first, dedupe | ||
dfs.sort_values(['domain','reason']).drop_duplicates(subset='domain', keep='first') | dfs.sort_values(['domain','reason']).drop_duplicates(subset=['domain','severity'], keep='first') | ||
# add columns and rename to match import format | # add columns and rename to match import format | ||
Line 38: | Line 36: | ||
dfs['#obfuscate'] = True | dfs['#obfuscate'] = True | ||
dfs = dfs.rename(columns={'domain':'#domain','severity':'#severity','reason':'#public_comment'}) | dfs = dfs.rename(columns={'domain':'#domain','severity':'#severity','reason':'#public_comment'}) | ||
# change 'severity' values to match import format | |||
dfs.loc[dfs['#severity']=='Limited','#severity'] = 'limit' | |||
dfs.loc[dfs['#severity']=='Suspended','#severity'] = 'suspend' | |||
# reorder | # reorder |