Merge Tables · Tools · CrossCompute

If two tables have the same column, then we can merge them into a single table by matching rows.

Thanks to the National Centers for Environmental Information for collecting temperature and precipitation data by state.

Table 1

Upload

State	Average Annual Temperature in Farenheit from 1971 to 2000
Alabama	62.8
Alaska	26.6
Arizona	60.3
Arkansas	60.4
California	59.4
Colorado	45.1
Connecticut	49.0
Delaware	55.3
Florida	70.7
Georgia	63.5
Hawaii	70.0
Idaho	44.4
Illinois	51.8
Indiana	51.7
Iowa	47.8
Kansas	54.3
Kentucky	55.6
Louisiana	66.4
Maine	41.0
Maryland	54.2
Massachusetts	47.9
Michigan	44.4
Minnesota	41.2
Mississippi	63.4
Missouri	54.5
Montana	42.7
Nebraska	48.8
Nevada	49.9
New Hampshire	43.8
New Jersey	52.7
New Mexico	53.4
New York	45.4
North Carolina	59.0
North Dakota	40.4
Ohio	50.7
Oklahoma	59.6
Oregon	48.4
Pennsylvania	48.8
Rhode Island	50.1
South Carolina	62.4
South Dakota	45.2
Tennessee	57.6
Texas	64.8
Utah	48.6
Vermont	42.9
Virginia	55.1
Washington	48.3
West Virginia	51.8
Wisconsin	43.1
Wyoming	42.0

Table 2

Upload

State	Average Annual Precipitation in Inches from 1971 to 2000
Alabama	58.3
Alaska	22.5
Arizona	13.6
Arkansas	50.6
California	22.2
Colorado	15.9
Connecticut	50.3
Delaware	45.7
Florida	54.5
Georgia	50.7
Hawaii	63.7
Idaho	18.9
Illinois	39.2
Indiana	41.7
Iowa	34.0
Kansas	28.9
Kentucky	48.9
Louisiana	60.1
Maine	42.2
Maryland	44.5
Massachusetts	47.7
Michigan	32.8
Minnesota	27.3
Mississippi	59.0
Missouri	42.2
Montana	15.3
Nebraska	23.6
Nevada	9.5
New Hampshire	43.4
New Jersey	47.1
New Mexico	14.6
New York	41.8
North Carolina	50.3
North Dakota	17.8
Ohio	39.1
Oklahoma	36.5
Oregon	27.4
Pennsylvania	42.9
Rhode Island	47.9
South Carolina	49.8
South Dakota	20.1
Tennessee	54.2
Texas	28.9
Utah	12.2
Vermont	42.7
Virginia	44.3
Washington	38.4
West Virginia	45.2
Wisconsin	32.6
Wyoming	12.9

Key Column

Pay Tool Creator: Roy Hyunjin Han	0
Pay Worker Creator: User for Manual Worker	?
Set Visibility: Hidden	0
Set Container: Numerical CPU with TINY Memory for 10 Minutes	0
Total	0