Question: Using python, write code for problem. The text files Senate113.txt, RetiredSen.txt and NewSen.txt are used in this problem and i have pasted contents of the
Using python, write code for problem. The text files Senate113.txt, RetiredSen.txt and NewSen.txt are used in this problem and i have pasted contents of the files. Please also put screenshot of your code.


Senate113.txt
Jeff Sessions,Alabama,R Richard Shelby,Alabama,R Lisa Murkowski,Alaska,R Mark Begich,Alaska,D John McCain,Arizona,R Jeff Flake,Arizona,R John Boozman,Arkansas,R Mark Pryor,Arkansas,D Barbara Boxer,California,D Dianne Feinstein,California,D Michael Bennet,Colorado,D Mark Udall,Colorado,D Richard Blumenthal,Connecticut,D Chris Murphy,Connecticut,D Thomas Carper,Delaware,D Chris Coons,Delaware,D Marco Rubio,Florida,R Bill Nelson,Florida,D Saxby Chambliss,Georgia,R Johnny Isakson,Georgia,R Brian Schatz,Hawaii,D Mazie Hirona,Hawaii,D Mike Crapo,Idaho,R Jim Risch,Idaho,R Richard Durbin,Illinois,D Mark Kirk,Illinois,R Dan Coats,Indiana,R Joe Donnelly,Indiana,D Chuck Grassley,Iowa,R Tom Harkin,Iowa,D Pat Roberts,Kansas,R Jerry Moran,Kansas,R Mitch McConnell,Kentucky,R Rand Paul,Kentucky,R Mary Landrieu,Louisiana,D David Vitter,Louisiana,R Susan Collins,Maine,R Angus King,Maine,I Benjamin Cardin,Maryland,D Barbara Mikulski,Maryland,D Edward Markey,Massachusetts,D Elizabeth Warren,Massachusetts,D Carl Levin,Michigan,D Debbie Stebenow,Michigan,D Amy Klobuchar,Minnesota,D Al Franken,Minnesota,D Thad Cochran,Mississippi,R Roger Wicker,Mississippi,R Roy Blunt,Missouri,R Claire McCaskill,Missouri,D Max Baucus,Montana,D John Walsh,Montana,D Mike Johanns,Nebraska,R Deb Fischer,Nebraska,R Dean Heller,Nevada,R Harry Reid,Nevada,D Kelly Ayotte,New Hampshire,R Jeanne Shaheen,New Hampshire,D Cory Booker,New Jersey,D Robert Menendez,New Jersey,D Tom Udall,New Mexico,D Martin Heinrich,New Mexico,D Charles Schumer,New York,D Kirsten Gillibrand,New York,D Richard Burr,North Carolina,R Kay Hagan,North Carolina,D John Hoeven,North Dakota,R Heidi Heitkamp,North Dakota,D Sherrod Brown,Ohio,D Rob Portman,Ohio,R Tom Coburn,Oklahoma,R James Inhofe,Oklahoma,R Ron Wyden,Oregon,D Jeff Merkley,Oregon,D Robert Casey,Pennsylvania,D Pat Toomey,Pennsylvania,R Jack Reed,Rhode Island,D Sheldon Whitehouse,Rhode Island,D Lindsey Graham,South Carolina,R Tim Scott,South Carolina,R Tim Johnson,South Dakota,D John Thune,South Dakota,R Lamar Alexander,Tennessee,R Bob Corker,Tennessee,R John Cornyn,Texas,R Ted Cruz,Texas,R Mike Lee,Utah,R Orrin Hatch,Utah,R Patrick Leahy,Vermont,D Bernard Sanders,Vermont,I Mark Warner,Virginia,D Tim Kaine,Virginia,D Maria Cantwell,Washington,D Patty Murray,Washington,D Joe Manchin,West Virginia,D John Rockefeller,West Virginia,D Tammy Baldwin,Wisconsin,D Ron Johnson,Wisconsin,R John Barrasso,Wyoming,R Michael Enzi,Wyoming,R
RetiredSen.txt
Mark Begich,Alaska,D Mark Pryor,Arkansas,D Mark Udall,Colorado,D Saxby Chambliss,Georgia,R Tom Harkin,Iowa,D Mary Landrieu,Louisiana,D Carl Levin,Michigan,D Mike Johanns,Nebraska,R Max Baucus,Montana,D Kay Hagan,North Carolina,D Tom Coburn,Oklahoma,R Tim Johnson,South Dakota,D John Rockefeller,West Virginia,D
Senate114.txt
Richard Shelby,Alabama,R Jeff Sessions,Alabama,R Dan Sullivan,Alaska,R Lisa Murkowski,Alaska,R John McCain,Arizona,R Jeff Flake,Arizona,R Tom Cotton,Arkansas,R John Boozman,Arkansas,R Dianne Feinstein,California,D Barbara Boxer,California,D Cory Gardner,Colorado,R Michael Bennet,Colorado,D Richard Blumenthal,Connecticut,D Chris Murphy,Connecticut,D Thomas Carper,Delaware,D Chris Coons,Delaware,D Bill Nelson,Florida,D Marco Rubio,Florida,R David Perdue,Georgia,R Johnny Isakson,Georgia,R Mazie Hirona,Hawaii,D Brian Schatz,Hawaii,D Mike Crapo,Idaho,R Jim Risch,Idaho,R Richard Durbin,Illinois,D Mark Kirk,Illinois,R Joe Donnelly,Indiana,D Dan Coats,Indiana,R Joni Ernst,Iowa,R Chuck Grassley,Iowa,R Jerry Moran,Kansas,R Pat Roberts,Kansas,R Mitch McConnell,Kentucky,R Rand Paul,Kentucky,R David Vitter,Louisiana,R Bill Cassidy,Louisiana,R Susan Collins,Maine,R Angus King,Maine,I Benjamin Cardin,Maryland,D Barbara Mikulski,Maryland,D Edward Markey,Massachusetts,D Elizabeth Warren,Massachusetts,D Gary Peters,Michigan,D Debbie Stebenow,Michigan,D Amy Klobuchar,Minnesota,D Al Franken,Minnesota,D Thad Cochran,Mississippi,R Roger Wicker,Mississippi,R Claire McCaskill,Missouri,D Roy Blunt,Missouri,R John Walsh,Montana,D Steve Daines,Montana,R Ben Sasse,Nebraska,R Deb Fischer,Nebraska,R Harry Reid,Nevada,D Dean Heller,Nevada,R Jeanne Shaheen,New Hampshire,D Kelly Ayotte,New Hampshire,R Cory Booker,New Jersey,D Robert Menendez,New Jersey,D Martin Heinrich,New Mexico,D Tom Udall,New Mexico,D Charles Schumer,New York,D Kirsten Gillibrand,New York,D Richard Burr,North Carolina,R Thom Tillis,North Carolina,R Heidi Heitkamp,North Dakota,D John Hoeven,North Dakota,R Sherrod Brown,Ohio,D Rob Portman,Ohio,R James Lankford,Oklahoma,R James Inhofe,Oklahoma,R Ron Wyden,Oregon,D Jeff Merkley,Oregon,D Robert Casey,Pennsylvania,D Pat Toomey,Pennsylvania,R Jack Reed,Rhode Island,D Sheldon Whitehouse,Rhode Island,D Lindsey Graham,South Carolina,R Tim Scott,South Carolina,R John Thune,South Dakota,R Mike Rounds,South Dakota,R Lamar Alexander,Tennessee,R Bob Corker,Tennessee,R John Cornyn,Texas,R Ted Cruz,Texas,R Mike Lee,Utah,R Orrin Hatch,Utah,R Patrick Leahy,Vermont,D Bernard Sanders,Vermont,I Mark Warner,Virginia,D Tim Kaine,Virginia,D Maria Cantwell,Washington,D Patty Murray,Washington,D Shelly Capito,West Virginia,R Joe Manchin,West Virginia,D Tammy Baldwin,Wisconsin,D Ron Johnson,Wisconsin,R John Barrasso,Wyoming,R Michael Enzi,Wyoming,R
4. U.S. Senate The file senatel13.txt contains the members of the 113th U.S. Senate that is, the Senate prior to the November 2014 election. Each record of the file consists of three fields name, state, and party affiliation. Some records in the file are as follows Richard Shelby ,Alabama,R Bernard Sanders,Vermont,I Kristen Gillibrand,New York,D The file Retiredsen.txt contains the records from the file senatel13.txt for senators who left the Senate after the November 2014 election due to retirement, defeat, death, or resignation. Some records in the file are as follows: John Rockefeller, West Virginia, Tom Coburn,Oklahoma,R Carl Levin, Michigan,D The file Newsen.txt contains records for the senators who were newly elected in November 2014 or who were appointed to fill the seats of senators who left after the November 2014 election. Some records in the file are as follows: Shelly West Virginia ,R Capito, Steve Daines, Montana,R Gary Peters, Michigan,D
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
