import csv
import requests
import matplotlib.pyplot as plt
from statistics import mean
import pandas as pd

link = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vRzbVTXqONdRaIFEcV1UX_vJ-f7yZUwdIwGkBqOkqsvahy7GiRlJ7D6rCMcI0opYLQPfSvUeUp7pg0b/pub?gid=530828056&single=true&output=csv'
response = requests.get(link)
tsv_data = response.text.split('\n')
reader = csv.DictReader(tsv_data)

reader = list(reader)
mid_parents = [
    mean(
        (float(row['father']), float(row['mother']))
    ) 
    for row in reader
]
adult_kids = [float(row['height']) for row in reader]

plt.scatter(mid_parents, adult_kids)
plt.title('Height')
plt.xlabel('mid parents')
plt.ylabel('adult kids')
plt.show()