List of all US Congress Members & Senators with Mirrored Surnames
Was ExcelFagging and used a string reverse function to get mirrors of the surnames. The PELOSI = ISOLEP Enterprises diggs from earlier made me thing of this. I went to Ballot Pedia and copied the list into excel then removed all formatting and hyperlinks and split the names using text to columns. I had to clean up the data because some fags have middle initials and some others have hyphenated last names. There may be a few errors but this is a good starting off point.
If (you) want to do this on (you)r own the only trick is going into VBA and creating the user defined function described here: https://www.excelforum.com/excel-formulas-and-functions/372757-how-to-reverse-contents-in-an-excel-cell-text-or-a-number.html
Public Function RevStr(Rng As Range)
RevStr = StrReverse(Rng.text)
End Function
Usage in your workbook cell is: =RevStr(cellref)
Easy peasy to import into Python, Excel, or (you)r spreadsheet of choice.
Think Mirror, per Q
(mirror is the second column)
Name (from Ballot Pedia),Surname,Mirror of Surname,Position,Date,Affiliation
Gary Peters,Peters,sreteP,U.S. Senate Michigan,1/6/2015,Democratic Party
Debbie Stabenow,Stabenow,wonebatS,U.S. Senate Michigan,1/3/2001,Democratic Party
Tim Kaine,Kaine,eniaK,U.S. Senate Virginia,1/3/2013,Democratic Party
Mark Warner,Warner,renraW,U.S. Senate Virginia,1/6/2009,Democratic Party
pastebin
https://pastebin.com/z31f1QCu
Comma Seperated Values