<SYSTEM_TASK:>
Given the following text description, write Python code to implement the functionality described below step by step
<END_TASK>
<USER_TASK:>
Description:
 First import pandas and numpy
Step1:  Use pd.read_excel in order to open file. If it says file not found, then make sure your directory is correct
Make sure you assign the file to a variable so it doesn't have to run every time
Step2:  Lets say we want to see the first 10 rows of the data to make sure it is the correct file (Google "pandas data preview") #table.tail is end of data
Step3:  What if I want to look at just one column of data
Step4:  What if I want to create a new column
Step5:  What if I want to find data in a certain set, such as only in Texas (Google) (panas find rows where value is)
Step6:  Run the following to get shape of table
Step7:  This is done to find the count of number of rows and number of cols
Step8:  Rows where you have some preset parameter, such as where lattitude is greater than 80 (Google) (Google same thing as above)
Step9:  Exercise
<ASSISTANT_TASK:>
Python Code:
import pandas as pd
import numpy as np
#Dont import matplotlib until we get to histogram example
import matplotlib.pyplot as plt
#This next line tells jupyter to plot it in the same space
%matplotlib inline
Explanation: First import pandas and numpy
End of explanation
table = pd.read_excel("GASISData.xls")
Explanation: Use pd.read_excel in order to open file. If it says file not found, then make sure your directory is correct
Make sure you assign the file to a variable so it doesn't have to run every time
End of explanation
table.head()
Explanation: Lets say we want to see the first 10 rows of the data to make sure it is the correct file (Google "pandas data preview") #table.tail is end of data
End of explanation
table['PLAYNAME']
Explanation: What if I want to look at just one column of data
End of explanation
table['NEW COLUMN'] = 5
table['NEW COLUMN'] 
Explanation: What if I want to create a new column
End of explanation
texasTable = table.loc[table['STATE'] == "TEXAS"]
print(texasTable)
Explanation: What if I want to find data in a certain set, such as only in Texas (Google) (panas find rows where value is)
End of explanation
sizeTable = table.shape
print(sizeTable)
Explanation: Run the following to get shape of table
End of explanation
num_rows = sizeTable[0]
num_cols = sizeTable[1]
print(num_rows)
print(num_cols)
Explanation: This is done to find the count of number of rows and number of cols
End of explanation
table.loc[table['LATITUDE'] > 10]
Explanation: Rows where you have some preset parameter, such as where lattitude is greater than 80 (Google) (Google same thing as above)
End of explanation
pd.DataFrame.hist(table,"AVPERM")
Explanation: Exercise: Make them find out how to rename columns
Exercise: (Usually we use Excel equations, now we are gonna practice this) Google how to add two columns together, and then create a new column with all these added values
Give them 5 mins for each excersice, help anyone around you
If you want to learn more, look it up at home on how to do other operators
Lets make a histogram of average permeability (In column CN), use column name not CN
Google this
End of explanation
<END_TASK>