Google Sheets Reader
import pandas as pd
import re
# This function will convert the url to a download link
def convert_gsheets_url(u):
try:
worksheet_id = u.split('#gid=')[1]
except:
# Couldn't get worksheet id. Ignore it
worksheet_id = None
u = re.findall('https://docs.google.com/spreadsheets/d/.*?/',u)[0]
u += 'export'
u += '?format=csv'
if worksheet_id:
u += '&gid={}'.format(worksheet_id)
return u
Run to view results
import pandas as pd
import numpy as np
Run to view results
create a plotly chart
import pandas as pd
import numpy as np
# Generate example data
data = {
'Index': range(1, 11),
'Value_A': np.random.randint(1, 100, size=10),
'Value_B': np.random.randint(50, 150, size=10)
}
example_df = pd.DataFrame(data)
example_df
Run to view results
a
Run to view results
a
Run to view results
a
Run to view results
a
Run to view results
a
Run to view results
a
Run to view results
Run to view results