#!/usr/bin/env python
# coding: utf-8

# In[20]:


import pandas as pd
names = ['Bob','Jessica','Mary','John','Mel']
grades = [76,95,77,78,99]
bsdegrees = [1,1,0,0,1]
msdegrees = [2,1,0,0,0]
phddegrees = [0,1,0,0,0]
Degrees = zip(names,grades,bsdegrees,msdegrees,phddegrees)
columns = ['Names','Grades','BS','MS','PhD']
df = pd.DataFrame(data = Degrees, columns=['Names','Grades','BS','MS','PhD'])
df


# In[2]:


import pandas as pd
pd.read_excel("datasets/gradedata.xlsx")


# In[3]:


import pandas as pd
pd.read_excel("datasets/gradedata.xlsx")
df.head()
df.columns = ['first','last','sex','age','exer','hrs','grd','addr']
df.head()


# In[9]:


import pandas as pd
pd.read_csv("04-01-2020.csv")
df.head()


# In[11]:


import pandas as pd
pd.read_csv("04-01-2020.csv")




# In[ ]:




