Data Cleaning Excel Tutorial
Data Cleaning Excel Tutorial
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
10 11 James K. Polk
11 12 Zachary Taylor
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
19 20 James A. Garfield
20 21 Chester A. Arthur
21 22 Grover Cleveland
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 Calvin Coolidge
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
38 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
44 45 Donald Trump
prior
Commander-in-Chief of the Continental Army ( 1775–1783 )
1st Vice President of the United States
2nd Vice President of the United States
5th United States Secretary of State (1801–1809)
7th United States Secretary of State (1811–1817)
8th United States Secretary of State (1817–1825)
U.S. Senator ( Class 2 ) from Tennessee (1823–1825)
8th Vice President of the United States
United States Minister to Colombia (1828–1829)
10th Vice President of the United States
9th Governor of Tennessee (1839–1841)
Major General of the 1st Infantry Regiment United States Army (1846–1849)
12th Vice President of the United States
Brigadier General of the 9th Infantry United States Army (1847–1848)
United States Minister to the Court of St James's (1853–1856)
U.S. Representative for Illinois' 7th District (1847–1849)
16th Vice President of the United States
Commanding General of the U.S. Army ( 1864–1869 )
29th & 32nd Governor of Ohio (1868–1872 & 1876–1877)
U.S. Representative for Ohio's 19th District (1863–1881)
20th Vice President of the United States
28th Governor of New York (1883–1885)
U.S. Senator ( Class 1 ) from Indiana (1881–1887)
22nd President of the United States (1885–1889)
39th Governor of Ohio (1892–1896)
25th Vice President of the United States
42nd United States Secretary of War (1904–1908)
34th Governor of New Jersey (1911–1913)
34th Governor of New Jersey (1911–1913)
U.S. Senator ( Class 3 ) from Ohio (1915–1921)
29th Vice President of the United States
3rd United States Secretary of Commerce (1921–1928)
44th Governor of New York ( 1929–1932 )
34th Vice President of the United States
Supreme Allied Commander Europe ( 1949–1952 )
U.S. Senator ( Class 1 ) from Massachusetts (1953–1960)
37th Vice President of the United States
36th Vice President of the United States (1953–1961)
40th Vice President of the United States
76th Governor of Georgia (1971–1975)
33rd Governor of California ( 1967–1975 )
43rd Vice President of the United States
40th & 42nd Governor of Arkansas (1979–1981 & 1983–1992)
46th Governor of Texas ( 1995–2000 )
U.S. Senator ( Class 3 ) from Illinois ( 2005–2008 )
Chairman of The Trump Organization ( 1971–present )
prior-fixed
Commander-in-Chief of the Continental Army ( 1775-1783 )
1st Vice President of the United States
2nd Vice President of the United States
5th United States Secretary of State (1801-1809)
7th United States Secretary of State (1811-1817)
8th United States Secretary of State (1817-1825)
U.S. Senator ( Class 2 ) from Tennessee (1823-1825)
8th Vice President of the United States
United States Minister to Colombia (1828-1829)
10th Vice President of the United States
9th Governor of Tennessee (1839-1841)
Major General of the 1st Infantry Regiment United States Army (1846-1849)
12th Vice President of the United States
Brigadier General of the 9th Infantry United States Army (1847-1848)
United States Minister to the Court of St James's (1853-1856)
U.S. Representative for Illinois' 7th District (1847-1849)
16th Vice President of the United States
Commanding General of the U.S. Army ( 1864-1869 )
29th & 32nd Governor of Ohio (1868-1872 & 1876-1877)
U.S. Representative for Ohio's 19th District (1863-1881)
20th Vice President of the United States
28th Governor of New York (1883-1885)
U.S. Senator ( Class 1 ) from Indiana (1881-1887)
22nd President of the United States (1885-1889)
39th Governor of Ohio (1892-1896)
25th Vice President of the United States
42nd United States Secretary of War (1904-1908)
34th Governor of New Jersey (1911-1913)
34th Governor of New Jersey (1911-1913)
U.S. Senator ( Class 3 ) from Ohio (1915-1921)
29th Vice President of the United States
3rd United States Secretary of Commerce (1921-1928)
44th Governor of New York ( 1929-1932 )
34th Vice President of the United States
Supreme Allied Commander Europe ( 1949-1952 )
U.S. Senator ( Class 1 ) from Massachusetts (1953-1960)
37th Vice President of the United States
36th Vice President of the United States (1953-1961)
40th Vice President of the United States
76th Governor of Georgia (1971-1975)
33rd Governor of California ( 1967-1975 )
43rd Vice President of the United States
40th & 42nd Governor of Arkansas (1979-1981 & 1983-1992)
46th Governor of Texas ( 1995-2000 )
U.S. Senator ( Class 3 ) from Illinois ( 2005-2008 )
Chairman of The Trump Organization ( 1971-present )
party vice salary
Nonpartisan John Adams 5000
Federalist Thomas Jefferson 10000
Democratic- Republican Aaron Burr 15000
Democratic- Republican George Clinton 20000
Democratic- Republican Daniel D. Tompkins 25000
Democratic- Republican John C. Calhoun 30000
Democratic John C. Calhoun 35000
Democratic Richard Mentor Johnson 40000
Whig John Tyler 45000
Whig Office vacant 50000
Democratic George M. Dallas 55000
Whig Millard Fillmore 60000
Whig Office vacant 65000
Democratic William R. King 75000
Democratic John C. Breckinridge 85000
Republican Hannibal Hamlin 95000
Democratic Office vacant 105000
Republican Schuyler Colfax 115000
Republican William A. Wheeler 125000
Republican Chester A. Arthur 135000
Republican Office vacant 145000
Democratic Thomas A. Hendricks 155000
Republican Levi P. Morton 165000
Democratic Adlai Stevenson 175000
Republican Garret Hobart 185000
Republican Office vacant 195000
Republican James S. Sherman 205000
Democratic Thomas R. Marshall 225000
Demorcatic Thomas R. Marshall 225000
Republican Calvin Coolidge 235000
Republican Office vacant 245000
Republican Charles Curtis 255000
Democratic John Nance Garner 265000
Democratic Office vacant 275000
Republican Richard Nixon 285000
Democratic Lyndon B. Johnson 295000
Democratic Office vacant 305000
Republican Spiro Agnew 315000
Republican Office vacant 325000
Democratic Walter Mondale 335000
Republican George H. W. Bush 345000
Republican Dan Quayle 355000
Democratic Al Gore 365000
Republican Dick Cheney 375000
Democratic Joe Biden 395000
Republican Mike Pence 405000
date updated date created
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 3/4/2012
7/14/2021 2/1/2020
7/14/2021 2/1/2020