0% found this document useful (0 votes)
2 views

Data Cleaning Excel Tutorial-1

The document lists the Presidents of the United States along with their respective political parties and vice presidents. It includes information on their salaries and the dates these figures were last updated. The data appears to be organized in a tabular format with some inconsistencies in the entries.

Uploaded by

bytradefx
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
2 views

Data Cleaning Excel Tutorial-1

The document lists the Presidents of the United States along with their respective political parties and vice presidents. It includes information on their salaries and the dates these figures were last updated. The data appears to be organized in a tabular format with some inconsistencies in the entries.

Uploaded by

bytradefx
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

S.No.

president
0 1 George Washington
1 2 john adams
2 3 Thomas Jefferson
3 4 James Madison
4 5 JAMES MONROE
5 6 John Quincy Adams
6 7 Andrew Jackson
7 8 Martin Van Buren
8 9 William Henry Harrison
9 10 john tyler
11 James K. Polk
8 9 William Henry Harrison
12 13 Millard Fillmore
13 14 Franklin Pierce
14 15 James Buchanan
15 16 Abraham Lincoln
16 17 Andrew Johnson
17 18 Ulysses S. Grant
18 19 Rutherford B. Hayes

20 21 Chester A. Arthur
17 18 Ulysses S. Grant
22 23 Benjamin Harrison
23 24 Grover Cleveland
24 25 William McKinley
25 26 Theodore Roosevelt
26 27 William Howard Taft
27 28 Woodrow Wilson
27 28 Woodrow Wilson
28 29 Warren G. Harding
29 30
30 31 Herbert Hoover
31 32 Franklin D. Roosevelt
32 33 Harry S. Truman
33 34 Dwight D. Eisenhower
34 35 John F. Kennedy
35 36 Lyndon B. Johnson
36 37 Richard Nixon
37 38 Gerald Ford
39 Jimmy Carter
39 40 Ronald Reagan
40 41 George H. W. Bush
41 42 Bill Clinton
42 43 George W. Bush
43 44 Barack Obama
43 44 Barack Obama
44 45 Donald Trump
prior party vice
Commander-in-Chief of the Nonpartisan John Adams
1st Vice President of the UnFederalist Thomas Jefferson
2nd Vice President of the UnDemocratic- Republican Aaron Burr
5th United States Secretary Democratic- Republican George Clinton
7th United States Secretary Democratic- Republican Daniel D. Tompkins
8th United States Secretary Democratic- Republican John C. Calhoun
U.S. Senator ( Class 2 ) Democratic John C. Calhoun
8th Vice President of the UnDemocratic Richard Mentor Johnson
United States Minister to Co Whig John Tyler
10th Vice President of the UWhig April 4, 1841 – September 13Office vacant
9th Governor of Tennessee Democratic George M. Dallas
United States Minister to Co Whig John Tyler
12th Vice President of the UWhig Office vacant
Brigadier General of the 9t Democratic William R. King
United States Minister to thDemocratic John C. Breckinridge
U.S. Representative for Illi Republican Hannibal Hamlin
16th Vice President of the UDemocratic Office vacant
Commanding General of theRepublican Schuyler Colfax
29th & 32nd Governor of O Republican William A. Wheeler

20th Vice President of the URepublican Office vacant


Commanding General of theRepublican Schuyler Colfax
U.S. Senator ( Class 1 ) f Republican Levi P. Morton
22nd President of the Unite Democratic Adlai Stevenson
39th Governor of Ohio (1 Republican Garret Hobart
25th Vice President of the URepublican Office vacant
42nd United States SecretarRepublican James S. Sherman
34th Governor of New JerseDemocratic Thomas R. Marshall
34th Governor of New JerseDemorcatic Thomas R. Marshall
U.S. Senator ( Class 3 ) f Republican Calvin Coolidge
29th Vice President of the URepublican Office vacant
3rd United States Secretar Republican Charles Curtis
44th Governor of New York Democratic John Nance Garner
34th Vice President of the UDemocratic Office vacant
Supreme Allied Commander REepublican Richard Nixon
U.S. Senator ( Class 1 ) Democratic Lyndon B. Johnson
37th Vice President of the UDemocratic Office vacant
36th Vice President of the Republican Spiro Agnew
40th Vice President of the URepublican Office vacant
76th Governor of Georgia Democratic Walter Mondale
33rd Governor of California Republican George H. W. Bush
43rd Vice President of the URepublican Dan Quayle
40th & 42nd Governor of A Democratic Al Gore
46th Governor of Texas ( Republican Dick Cheney
U.S. Senator ( Class 3 ) fro Democratic
U.S. Senator ( Class 3 ) fro Democratic Joe Biden
Chairman of The Trump Orga Republicans Mike Pence
salary date updated
$5,000.00 7/14/2021
$10,000.00 7/14/2021
$15,000.00 7/14/2021
$20,000.00 7/14/2021
$25,000.00 7/14/2021
$30,000.00 7/14/2021
$35,000.00 7/14/2021
7/14/2021
$45,000.00 7/14/2021
$50,000.00 7/14/2021
$55,000.00 7/14/2021
$45,000.00 7/14/2021
$65,000.00 7/14/2021
$75,000.00 7/14/2021
$85,000.00 7/14/2021
$95,000.00 7/14/2021
$105,000.00 7/14/2021
$115,000.00 7/14/2021
$125,000.00 7/14/2021

$145,000.00 7/14/2021
$115,000.00 7/14/2021
$165,000.00 7/14/2021
$175,000.00 7/14/2021
$185,000.00 7/14/2021
$195,000.00 7/14/2021
$205,000.00 7/14/2021
$225,000.00 7/14/2021
$225,000.00 7/14/2021
$235,000.00 7/14/2021
$245,000.00 7/14/2021
$255,000.00 7/14/2021
$265,000.00 7/14/2021
$275,000.00 7/14/2021
$285,000.00 7/14/2021
$295,000.00 7/14/2021
$305,000.00 7/14/2021
$315,000.00 7/14/2021
$325,000.00 7/14/2021
$335,000.00 7/14/2021
$345,000.00 7/14/2021
$355,000.00 7/14/2021
$365,000.00 7/14/2021
$375,000.00 7/14/2021
$395,000.00 7/14/2021
$395,000.00 7/14/2021
$405,000.00 7/14/2021
date created
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012

3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
3/4/2012
Saturday, February 1, 2020
Saturday, February 1, 2020
Saturday, February 1, 2020

You might also like