Defederated Instances/Imports: Difference between revisions

no edit summary
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')
 


# change 'severity' values to match import format
dfs.loc[dfs['#severity']=='Limited','#severity'] = 'limit'
dfs.loc[dfs['#severity']=='Suspended','#severity'] = 'suspend'


# 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