# sorts the dataframe so resulting order of ColumnName matches order in list df = df.set_index(ColumnName).reindex(list_to_sort_by).reset_index()