First import pandas and numpy
In [21]:
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
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
In [3]:
table = pd.read_excel("GASISData.xls")
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
In [8]:
table.head()
Out[8]:
LINKA
STATE
FLDNAME
RESNAME
R_STUDY
PLAYNAME
PLAYCOD
SUBPLAYN
SUBPLAY
DOEFLD
...
HELIUM
OTHER
HEAT
ATLASREG
RTYPEGOR
USGSPROV
USGSPLAY
S_USGSPL
PLAYDEPO
TYPELOGF
0
1
ALABAMA
ALOE BAY
NORPHLET
A
UPPER JURASSIC AGGRADATIONAL SANDSTONE
UU A.1
NaN
NaN
14081.0
...
0.00
0.0
0
GM
G
NaN
NaN
NaN
NaN
NaN
1
2
ALABAMA
BEAVERTON
CARTER NE
R
PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
GCPN-MS-1
NaN
NaN
50317.0
...
0.07
0.0
1005
EG
G
65.0
6502.0
O
DELTA
AL000001
2
3
ALABAMA
BEAVERTON
CARTER SE
R
PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
GCPN-MS-1
NaN
NaN
50317.0
...
0.07
0.0
1005
EG
G
65.0
6502.0
O
DELTA
AL000002
3
4
ALABAMA
BEAVERTON
LEWIS
R
PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
GCPN-MS-1
NaN
NaN
50317.0
...
0.00
0.0
0
EG
G
65.0
6502.0
O
DELTA
AL000003
4
5
ALABAMA
BETHEL CHURCH
CARTER
R
PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
GCPN-MS-1
NaN
NaN
1994.0
...
0.08
0.5
1004
EG
G
65.0
6502.0
O
DELTA
AL000004
5 rows × 186 columns
What if I want to look at just one column of data
In [9]:
table['PLAYNAME']
Out[9]:
0 UPPER JURASSIC AGGRADATIONAL SANDSTONE
1 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
2 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
3 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
4 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
5 UPPER JURASSIC SHALLOW-MARINE CARBONATE AND SA...
6 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
7 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
8 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
9 PENNSYLVANIAN COALBED METHANE-ALABAMA
10 UPPER JURASSIC AGGRADATIONAL SANDSTONE
11 PENNSYLVANIAN COALBED METHANE-ALABAMA
12 PENNSYLVANIAN COALBED METHANE-ALABAMA
13 UPPER JURASSIC SHALLOW-MARINE CARBONATE AND SA...
14 UPPER JURASSIC SHALLOW-MARINE CARBONATE AND SA...
15 TRINITY GROUP SANDSTONE-MISSISSIPPI INTERIOR S...
16 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
17 UPPER JURASSIC SHALLOW-MARINE CARBONATE AND SA...
18 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
19 LOWER UPPER MIOCENE COMBINATION SANDSTONE
20 LOWER UPPER MIOCENE COMBINATION SANDSTONE
21 UPPER MIDDLE MIOCENE COMBINATION SANDSTONE
22 LOWER UPPER MIOCENE COMBINATION SANDSTONE
23 UPPER MIDDLE MIOCENE COMBINATION SANDSTONE
24 LOWER UPPER MIOCENE COMBINATION SANDSTONE
25 UPPER JURASSIC AGGRADATIONAL SANDSTONE
26 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
27 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
28 PENNSYLVANIAN COALBED METHANE-ALABAMA
29 PENNSYLVANIAN-MISSISSIPPIAN DELTAIC AND MARINE...
...
19190 WIND RIVER BASIN
19191 MESAVERDE GROUP
19192 MESAVERDE GROUP
19193 LEWIS SHALE (AND FOX HILLS SANDSTONE)
19194 MESAVERDE GROUP
19195 MESAVERDE GROUP
19196 GREATER GREEN RIVER BASIN
19197 FORT UNION FORMATION
19198 LANCE FORMATION
19199 NaN
19200 LEWIS SHALE (AND FOX HILLS SANDSTONE)
19201 LANCE FORMATION
19202 DAKOTA/FALL RIVER SANDSTONE
19203 FRONTIER FORMATION
19204 FRONTIER FORMATION
19205 DAKOTA/FALL RIVER SANDSTONE
19206 ORDOVICIAN BIGHORN DOLOMITE
19207 MISSISSIPPIAN MADISON/MISSION CANYON LIMESTONE
19208 MISSISSIPPIAN MADISON/MISSION CANYON LIMESTONE
19209 TRIASSIC THAYNES LIMESTONE
19210 PENNSYLVANIAN WEBER SANDSTONE
19211 MESAVERDE GROUP
19212 MESAVERDE GROUP
19213 MUDDY SANDSTONE
19214 FRONTIER FORMATION
19215 FRONTIER FORMATION
19216 BIGHORN BASIN
19217 BIGHORN BASIN
19218 PERMIAN PHOSPHORIA FORMATION
19219 JURASSIC TWIN CREEK LIMESTONE
Name: PLAYNAME, dtype: object
What if I want to create a new column
In [11]:
table['NEW COLUMN'] = 5
table['NEW COLUMN']
Out[11]:
0 5
1 5
2 5
3 5
4 5
5 5
6 5
7 5
8 5
9 5
10 5
11 5
12 5
13 5
14 5
15 5
16 5
17 5
18 5
19 5
20 5
21 5
22 5
23 5
24 5
25 5
26 5
27 5
28 5
29 5
..
19190 5
19191 5
19192 5
19193 5
19194 5
19195 5
19196 5
19197 5
19198 5
19199 5
19200 5
19201 5
19202 5
19203 5
19204 5
19205 5
19206 5
19207 5
19208 5
19209 5
19210 5
19211 5
19212 5
19213 5
19214 5
19215 5
19216 5
19217 5
19218 5
19219 5
Name: NEW COLUMN, dtype: int64
What if I want to find data in a certain set, such as only in Texas (Google) (panas find rows where value is)
In [14]:
texasTable = table.loc[table['STATE'] == "TEXAS"]
print(texasTable)
LINKA STATE FLDNAME RESNAME R_STUDY \
12712 12713 TEXAS A W P OLMOS T
12713 12714 TEXAS ABELL CLEAR FORK T
12714 12715 TEXAS ABELL DEVONIAN T
12715 12716 TEXAS ABELL PERMIAN GENERAL T
12716 12717 TEXAS ABELL EAST GLORIETA * T
12717 12718 TEXAS ACEVEDO LOBO 6 T
12718 12719 TEXAS ACKERLY DEAN SAND T
12719 12720 TEXAS ADAIR NO NAME T
12720 12721 TEXAS ADAIR WOLFCAMP T
12721 12722 TEXAS ADAMC BEND T
12722 12723 TEXAS ADAMC DEVONIAN T
12723 12724 TEXAS ADAMS RANCH NODOSARIA T
12724 12725 TEXAS ADAMS-BAGGETT RANCH CANYON SAND T
12725 12726 TEXAS AGARITO LOBO T
12726 12727 TEXAS AGARITTA KING SAND T
12727 12728 TEXAS AGGIELAND WOODBINE T
12728 12729 TEXAS AGUA DULCE 4900 T
12729 12730 TEXAS AGUA DULCE 5000 T
12730 12731 TEXAS AGUA DULCE 5100 T
12731 12732 TEXAS AGUA DULCE 5200 T
12732 12733 TEXAS AGUA DULCE 5300 T
12733 12734 TEXAS AGUA DULCE 5450 T
12734 12735 TEXAS AGUA DULCE 5600 T
12735 12736 TEXAS AGUA DULCE 6100 T
12736 12737 TEXAS AGUA DULCE 6600 T
12737 12738 TEXAS AGUA DULCE 7000 T
12738 12739 TEXAS AGUA DULCE 7550 T
12739 12740 TEXAS AGUA DULCE 8300 T
12740 12741 TEXAS AGUA DULCE 8400 T
12741 12742 TEXAS AGUA DULCE 8570 T
... ... ... ... ... ...
18045 18046 TEXAS YANTIS SW SMACKOVER R
18046 18047 TEXAS YANTIS WEST SMACKOVER T
18047 18048 TEXAS YATES NO NAME T
18048 18049 TEXAS YEARY FIMBLE T
18049 18050 TEXAS YEARY HUFF T
18050 18051 TEXAS YEARY KNOX T
18051 18052 TEXAS YEARY MORGAN T
18052 18053 TEXAS YEARY MORGAN UPPER T
18053 18054 TEXAS YEARY STUBBS T
18054 18055 TEXAS YEARY WALSH T
18055 18056 TEXAS YOAKUM 8600 T
18056 18057 TEXAS YOAKUM WILCOX 8800 T
18057 18058 TEXAS YORKTOWN WILCOX B 10400 T
18058 18059 TEXAS YORKTOWN WILCOX LOWER 11000 T
18059 18060 TEXAS YORKTOWN SOUTH WILCOX T
18060 18061 TEXAS YORKTOWN SOUTH WILCOX 11100 T
18061 18062 TEXAS YOUGEEN NO NAME T
18062 18063 TEXAS YOUGEEN VICKSBURG 3700 T
18063 18064 TEXAS YOUGEEN VICKSBURG 3800 T
18064 18065 TEXAS YOUNG COUNTY REGULAR NO NAME T
18065 18066 TEXAS YOUNG COUNTY REGULAR NO NAME T
18066 18067 TEXAS YOWARD NO NAME T
18067 18068 TEXAS YTURRIA 4100 T
18068 18069 TEXAS YTURRIA RINCON 4900 T
18069 18070 TEXAS YUCCA BUTTE PENNSYLVANIAN DETRITAL T
18070 18071 TEXAS YUCCA BUTTE WEST ELLENBURGER R
18071 18072 TEXAS YUCCA BUTTE WEST STRAWN R
18072 18073 TEXAS ZIM-RICABY 2600, SOUTH T
18073 18074 TEXAS ZONE 21-B TREND ZONE 21-B TREND T
18074 18075 TEXAS ZULCH NORTH SUB CLARKSVILLE T
PLAYNAME PLAYCOD \
12712 NaN NaN
12713 CLEAR FORK PLATFORM CARBONATE TXPM-3
12714 SILURO-DEVONIAN EROSIONAL TRUNCATION TXSD-2
12715 NaN NaN
12716 NaN NaN
12717 NaN NaN
12718 SPRABERRY AND DEAN SANDSTONE, MIDLAND BASIN TXPM-2
12719 SAN ANDRES AND GRAYBURG PLATFORM CARBONATE TXPM-4
12720 UPPER PENNSYLVANIAN CARBONATE TXPN-4
12721 ATOKA GROUP LIMESTONE AND SANDSTONE TXPN-1
12722 SILURO-DEVONIAN SHELF CARBONATE-MIDLAND BASIN TXSD-3
12723 FRIO BARRIER/STRANDPLAIN AND SLOPE SANDSTONE I... TXFR-10
12724 UPPER PENNSYLVANIAN AND LOWER PERMIAN SLOPE AN... TXPN-5
12725 NaN NaN
12726 NaN NaN
12727 NaN NaN
12728 NaN NaN
12729 FRIO FLUVIAL/DELTAIC SANDSTONE ALONG THE VICKS... TXFR-4
12730 FRIO FLUVIAL/DELTAIC SANDSTONE ALONG THE VICKS... TXFR-4
12731 FRIO FLUVIAL/DELTAIC SANDSTONE ALONG THE VICKS... TXFR-4
12732 NaN NaN
12733 FRIO FLUVIAL/DELTAIC SANDSTONE ALONG THE VICKS... TXFR-4
12734 FRIO FLUVIAL/DELTAIC SANDSTONE ALONG THE VICKS... TXFR-4
12735 NaN NaN
12736 FRIO FLUVIAL/DELTAIC SANDSTONE ALONG THE VICKS... TXFR-4
12737 NaN NaN
12738 VICKSBURG DELTAIC SANDSTONE IN THE RIO GRANDE ... TXVK-1
12739 NaN NaN
12740 FRIO FLUVIAL/DELTAIC SANDSTONE ALONG THE VICKS... TXFR-4
12741 NaN NaN
... ... ...
18045 SMACKOVER SHALLOW-MARINE CARBONATE TXJC-1
18046 SMACKOVER SHALLOW-MARINE CARBONATE TXJC-1
18047 SAN ANDRES AND GRAYBURG PLATFORM CARBONATE TXPM-4
18048 PROXIMAL FRIO DELTAIC SANDSTONE IN THE RIO GRA... TXFR-3
18049 PROXIMAL FRIO DELTAIC SANDSTONE IN THE RIO GRA... TXFR-3
18050 PROXIMAL FRIO DELTAIC SANDSTONE IN THE RIO GRA... TXFR-3
18051 PROXIMAL FRIO DELTAIC SANDSTONE IN THE RIO GRA... TXFR-3
18052 PROXIMAL FRIO DELTAIC SANDSTONE IN THE RIO GRA... TXFR-3
18053 PROXIMAL FRIO DELTAIC SANDSTONE IN THE RIO GRA... TXFR-3
18054 PROXIMAL FRIO DELTAIC SANDSTONE IN THE RIO GRA... TXFR-3
18055 NaN NaN
18056 WILCOX DELTAIC SANDSTONE IN THE HOUSTON EMBAYMENT TXWX-1
18057 WILCOX DELTAIC SANDSTONE IN THE RIO GRANDE EMB... TXWX-4
18058 WILCOX DELTAIC SANDSTONE IN THE RIO GRANDE EMB... TXWX-4
18059 NaN NaN
18060 WILCOX DELTAIC SANDSTONE IN THE RIO GRANDE EMB... TXWX-4
18061 NaN NaN
18062 VICKSBURG SANDSTONE UPDIP FROM THE VICKSBURG F... TXVK-2
18063 NaN NaN
18064 NaN NaN
18065 LOWER AND MIDDLE PENNSYLVANIAN FAN-DELTA SANDS... TXPN-7
18066 NaN NaN
18067 NaN NaN
18068 NaN NaN
18069 STRAWN GROUP SHALLOW-MARINE CARBONATE TXPN-2
18070 ELLENBURGER FRACTURED DOLOSTONE TXOR-1
18071 STRAWN GROUP SHALLOW-MARINE CARBONATE TXPN-2
18072 NaN NaN
18073 FRIO FLUVIAL/DELTAIC SANDSTONE ALONG THE VICKS... TXFR-4
18074 UPPER CRETACEOUS SANDSTONE-DOWNDIP SHELF MARGIN TXKS-3
SUBPLAYN SUBPLAY DOEFLD \
12712 NaN NaN 6990.0
12713 NaN NaN 1652.0
12714 NaN NaN 1652.0
12715 NaN NaN 1652.0
12716 NaN NaN 1683.0
12717 NaN NaN 10001.0
12718 NaN NaN 2427.0
12719 PLATFORM CARBONATES, CENTRAL BASIN PLATFORM TXPM-4A 3109.0
12720 NaN NaN 3109.0
12721 NaN NaN 3233.0
12722 NaN NaN 3233.0
12723 NaN NaN 3574.0
12724 NaN NaN 3357.0
12725 NaN NaN 13175.0
12726 NaN NaN 13176.0
12727 NaN NaN 6329.0
12728 NaN NaN 5217.0
12729 NaN NaN 5217.0
12730 NaN NaN 5217.0
12731 NaN NaN 5217.0
12732 NaN NaN 5217.0
12733 NaN NaN 5217.0
12734 NaN NaN 5217.0
12735 NaN NaN 5217.0
12736 NaN NaN 5217.0
12737 NaN NaN 5217.0
12738 NaN NaN 5217.0
12739 NaN NaN 5217.0
12740 NaN NaN 5217.0
12741 NaN NaN 5217.0
... ... ... ...
18045 NaN NaN 785294.0
18046 NaN NaN 785325.0
18047 NaN NaN 785511.0
18048 NaN NaN 785930.0
18049 NaN NaN 785930.0
18050 NaN NaN 785930.0
18051 NaN NaN 785930.0
18052 NaN NaN 785930.0
18053 NaN NaN 785930.0
18054 NaN NaN 785930.0
18055 NaN NaN 787118.0
18056 NaN NaN 787118.0
18057 NaN NaN 787614.0
18058 NaN NaN 787614.0
18059 NaN NaN 787707.0
18060 NaN NaN 787707.0
18061 NaN NaN 787769.0
18062 NaN NaN 787769.0
18063 NaN NaN 787769.0
18064 NaN NaN 787924.0
18065 NaN NaN 787924.0
18066 NaN NaN 788482.0
18067 NaN NaN 788948.0
18068 NaN NaN 788948.0
18069 NaN NaN 789010.0
18070 NaN NaN 789024.0
18071 NaN NaN 789024.0
18072 NaN NaN 791734.0
18073 NaN NaN 792866.0
18074 NaN NaN 793443.0
... OTHER HEAT ATLASREG RTYPEGOR USGSPROV USGSPLAY S_USGSPL \
12712 ... 0.0 0 TX O 47.0 4716.0 O
12713 ... 0.1 1098 TX O 44.0 4410.0 E
12714 ... 0.0 0 TX O 44.0 4402.0 E
12715 ... 0.0 0 TX O 44.0 4410.0 E
12716 ... 0.0 0 TX G 44.0 4410.0 O
12717 ... 0.0 0 TX G NaN NaN NaN
12718 ... 0.0 0 TX O 44.0 4410.0 O
12719 ... 0.0 0 TX O 44.0 4410.0 E
12720 ... 0.0 0 TX O 44.0 4405.0 O
12721 ... 0.0 0 TX O 44.0 4404.0 O
12722 ... 0.0 0 TX O 44.0 4402.0 O
12723 ... 0.0 0 TX G 47.0 4701.0 E
12724 ... 0.0 0 TX G 44.0 4407.0 O
12725 ... 0.0 0 TX G 47.0 4718.0 O
12726 ... 0.0 0 TX O NaN NaN NaN
12727 ... 0.0 0 TX O 47.0 4710.0 O
12728 ... 0.0 1147 TX G 47.0 4732.0 E
12729 ... 0.0 1147 TX G 47.0 4732.0 E
12730 ... 0.0 1147 TX G 47.0 4732.0 E
12731 ... 0.0 1147 TX G 47.0 4732.0 E
12732 ... 0.0 1147 TX G 47.0 4732.0 E
12733 ... 0.0 1147 TX G 47.0 4732.0 E
12734 ... 0.0 1147 TX G 47.0 4732.0 E
12735 ... 0.0 1147 TX G 47.0 4732.0 E
12736 ... 0.0 1147 TX G 47.0 4732.0 E
12737 ... 0.0 1147 TX G 47.0 4732.0 E
12738 ... 0.0 0 TX G 47.0 4730.0 E
12739 ... 0.0 0 TX G 47.0 4732.0 E
12740 ... 0.0 1147 TX G 47.0 4732.0 E
12741 ... 0.0 1147 TX G 47.0 4732.0 E
... ... ... ... ... ... ... ... ...
18045 ... 0.0 0 TX G 49.0 4912.0 O
18046 ... 0.1 983 TX G 49.0 4912.0 O
18047 ... 0.0 0 TX O 44.0 4410.0 O
18048 ... 0.0 0 TX G 47.0 4733.0 O
18049 ... 0.0 0 TX G 47.0 4733.0 O
18050 ... 0.0 0 TX G 47.0 4733.0 O
18051 ... 0.0 0 TX G 47.0 4733.0 O
18052 ... 0.0 0 TX G 47.0 4733.0 O
18053 ... 0.0 0 TX G 47.0 4733.0 O
18054 ... 0.0 0 TX G 47.0 4733.0 O
18055 ... 0.0 1122 TX G 47.0 4722.0 O
18056 ... 0.0 1122 TX G 47.0 4722.0 O
18057 ... 0.1 1278 TX G 47.0 4719.0 E
18058 ... 0.1 1278 TX G 47.0 4720.0 O
18059 ... 0.8 1147 TX G 47.0 4720.0 O
18060 ... 0.8 1147 TX G 47.0 4720.0 O
18061 ... 0.0 0 TX O 47.0 4730.0 O
18062 ... 0.0 0 TX G 47.0 4730.0 O
18063 ... 0.0 0 TX G 47.0 4730.0 O
18064 ... 0.0 0 TX O 45.0 4505.0 E
18065 ... 0.0 0 TX G 45.0 4505.0 E
18066 ... 0.0 0 TX O 47.0 4720.0 E
18067 ... 0.0 0 TX G 47.0 4733.0 O
18068 ... 0.0 0 TX O 47.0 4731.0 O
18069 ... 0.0 0 TX G 44.0 4406.0 E
18070 ... 0.0 0 TX O 44.0 4401.0 O
18071 ... 0.0 0 TX O 44.0 4407.0 O
18072 ... 0.0 0 TX G 47.0 4728.0 E
18073 ... 0.0 0 TX G 47.0 4731.0 E
18074 ... 0.0 0 TX G 47.0 4710.0 O
PLAYDEPO TYPELOGF NEW COLUMN
12712 NaN NaN 5
12713 NaN NaN 5
12714 NaN NaN 5
12715 NaN NaN 5
12716 NaN NaN 5
12717 NaN NaN 5
12718 SLBAS NaN 5
12719 NaN NaN 5
12720 REEF NaN 5
12721 NaN NaN 5
12722 SHSHF NaN 5
12723 STRAN NaN 5
12724 SLBAS NaN 5
12725 NaN NaN 5
12726 NaN NaN 5
12727 NaN NaN 5
12728 NaN NaN 5
12729 DELTA NaN 5
12730 DELTA NaN 5
12731 DELTA NaN 5
12732 NaN NaN 5
12733 DELTA NaN 5
12734 DELTA NaN 5
12735 NaN NaN 5
12736 DELTA NaN 5
12737 NaN NaN 5
12738 DELTA NaN 5
12739 NaN NaN 5
12740 DELTA NaN 5
12741 NaN NaN 5
... ... ... ...
18045 SHSHF TX000161 5
18046 SHSHF NaN 5
18047 PERIT NaN 5
18048 DELTA NaN 5
18049 DELTA NaN 5
18050 DELTA NaN 5
18051 DELTA NaN 5
18052 DELTA NaN 5
18053 DELTA NaN 5
18054 DELTA NaN 5
18055 NaN NaN 5
18056 DELTA NaN 5
18057 DELTA NaN 5
18058 DELTA NaN 5
18059 NaN NaN 5
18060 DELTA NaN 5
18061 NaN NaN 5
18062 DELTA NaN 5
18063 NaN NaN 5
18064 NaN NaN 5
18065 AFAN NaN 5
18066 NaN NaN 5
18067 NaN NaN 5
18068 NaN NaN 5
18069 SHSHF NaN 5
18070 NaN TX000242 5
18071 NaN TX000243 5
18072 NaN NaN 5
18073 DELTA NaN 5
18074 SHMAR NaN 5
[5363 rows x 187 columns]
Run the following to get shape of table
In [4]:
sizeTable = table.shape
print(sizeTable)
(19220, 186)
This is done to find the count of number of rows and number of cols
In [6]:
num_rows = sizeTable[0]
num_cols = sizeTable[1]
print(num_rows)
print(num_cols)
19220
186
Rows where you have some preset parameter, such as where lattitude is greater than 80 (Google) (Google same thing as above)
In [16]:
table.loc[table['LATITUDE'] > 10]
Out[16]:
LINKA
STATE
FLDNAME
RESNAME
R_STUDY
PLAYNAME
PLAYCOD
SUBPLAYN
SUBPLAY
DOEFLD
...
OTHER
HEAT
ATLASREG
RTYPEGOR
USGSPROV
USGSPLAY
S_USGSPL
PLAYDEPO
TYPELOGF
NEW COLUMN
453
454
KENTUCKY
ADAMS
357CLNN
A
LOWER SILURIAN CATARACT/MEDINA GROUP ('CLINTON...
Scm
NaN
NaN
3326.0
...
0.0
1026
AP
G
67.0
6728.0
E
DELTA
NaN
5
454
455
KENTUCKY
ALBANY CONS.
365SBRK
A
MIDDLE AND UPPER ORDOVICIAN BIOCLASTIC CARBONA...
Obc
NaN
NaN
NaN
...
0.0
0
AP
G
67.0
6703.0
E
SHSHF
NaN
5
455
456
KENTUCKY
ALBANY CONS.
365SRVR
A
MIDDLE ORDOVICIAN FRACTURED CARBONATES
MOf
NaN
NaN
NaN
...
0.0
0
AP
G
67.0
6703.0
E
SHSHF
NaN
5
456
457
KENTUCKY
ALBANY CONS.
368KNOX
A
CAMBRIAN-ORDOVICIAN KNOX GROUP UNCONFORMITY
COk
NaN
NaN
NaN
...
0.0
0
AP
G
67.0
6703.0
E
SHSHF
NaN
5
457
458
KENTUCKY
ALBANY NORTH
365TRNN
A
MIDDLE ORDOVICIAN FRACTURED CARBONATES
MOf
NaN
NaN
4645.0
...
0.0
0
AP
G
66.0
6602.0
E
SHSHF
NaN
5
458
459
KENTUCKY
ALBANY SOUTH
337FRPN
A
LOWER MISSISSIPPIAN FORT PAYNE CARBONATE MOUND...
Mfp
NaN
NaN
7356.0
...
0.0
0
AP
G
66.0
6605.0
E
REEF
NaN
5
459
460
KENTUCKY
ALLEN CITY DBS
327LEE
A
LOWER AND MIDDLE PENNSYLVANIAN POTTSVILLE, NEW...
Pps
NaN
NaN
11642.0
...
0.0
0
AP
G
67.0
6725.0
E
DELTA
NaN
5
460
461
KENTUCKY
ALLEN CITY DBS
332BGLM
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
11642.0
...
0.0
0
AP
G
67.0
6725.0
E
SHSHF
NaN
5
461
462
KENTUCKY
ALLEN CITY DBS
332MXON
A
UPPER MISSISSIPPIAN MAUCH CHUNK GROUP AND EQUI...
Mmc
NaN
NaN
11642.0
...
0.0
1167
AP
G
67.0
6725.0
E
DELTA
NaN
5
462
463
KENTUCKY
ALLEN CITY DBS
337BGIJ
A
LOWER MISSISSIPPIAN BIG INJUN SANDSTONES
Mbi
NaN
NaN
11642.0
...
0.0
1151
AP
G
67.0
6725.0
E
DELTA
NaN
5
463
464
KENTUCKY
ALVA
341OHIO
A
UPPER DEVONIAN BLACK SHALES
UDs
NaN
NaN
14296.0
...
0.0
0
AP
G
67.0
6740.0
E
DELTA
NaN
5
464
465
KENTUCKY
ALVIN NORTH DBS
332MXON
A
UPPER MISSISSIPPIAN MAUCH CHUNK GROUP AND EQUI...
Mmc
NaN
NaN
NaN
...
0.0
1148
AP
G
67.0
6725.0
E
DELTA
NaN
5
465
466
KENTUCKY
ARGO DBS
332BGLM
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
24081.0
...
0.0
0
AP
G
67.0
6725.0
E
SHSHF
NaN
5
466
467
KENTUCKY
ARGO DBS
332MXON
A
UPPER MISSISSIPPIAN MAUCH CHUNK GROUP AND EQUI...
Mmc
NaN
NaN
24081.0
...
0.0
0
AP
G
67.0
6725.0
E
DELTA
NaN
5
467
468
KENTUCKY
ARTEMUS-HIMYAR CONS.
332BGLM
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
4655.0
...
0.0
0
AP
O
67.0
6725.0
E
SHSHF
NaN
5
468
469
KENTUCKY
ARTEMUS-HIMYAR CONS.
332MXON
A
UPPER MISSISSIPPIAN MAUCH CHUNK GROUP AND EQUI...
Mmc
NaN
NaN
4655.0
...
0.0
1107
AP
O
67.0
6725.0
E
DELTA
NaN
5
469
470
KENTUCKY
ARTEMUS-HIMYAR CONS.
337BGIJ
A
LOWER MISSISSIPPIAN BIG INJUN SANDSTONES
Mbi
NaN
NaN
4655.0
...
0.0
0
AP
G
67.0
6725.0
E
DELTA
NaN
5
470
471
KENTUCKY
ARTEMUS-HIMYAR CONS.
341OHIO
A
UPPER DEVONIAN BLACK SHALES
UDs
NaN
NaN
4655.0
...
0.0
0
AP
G
67.0
6741.0
E
DELTA
NaN
5
471
472
KENTUCKY
ARTEMUS-HIMYAR CONS.
355LCKP
A
LOWER DEVONIAN-UPPER SILURIAN UNCONFORMITY PLAY
DSu
NaN
NaN
4655.0
...
0.0
1183
AP
G
67.0
6717.0
E
SHSHF
NaN
5
472
473
KENTUCKY
ARY DBS
332BGLM
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
4656.0
...
0.0
0
AP
O
67.0
6725.0
E
SHSHF
NaN
5
473
474
KENTUCKY
ARY DBS
355BGSX
A
UPPER SILURIAN LOCKPORT DOLOMITE-KEEFER (BIG S...
Sld
NaN
NaN
4656.0
...
0.0
1061
AP
G
67.0
6715.0
E
SHELF
NaN
5
474
475
KENTUCKY
ASHER
341OHIO
A
UPPER DEVONIAN BLACK SHALES
UDs
NaN
NaN
27553.0
...
0.0
1204
AP
G
67.0
6740.0
E
DELTA
NaN
5
475
476
KENTUCKY
ASHLAND
327LEE
A
LOWER AND MIDDLE PENNSYLVANIAN POTTSVILLE, NEW...
Pps
NaN
NaN
27770.0
...
0.0
0
AP
G
67.0
6725.0
E
DELTA
NaN
5
476
477
KENTUCKY
ASHLAND
339BERE
A
LOWER MISSISSIPPIAN-UPPER DEVONIAN BEREA FLUVI...
MDe
NaN
NaN
27770.0
...
0.0
1083
AP
O
67.0
6725.0
E
DELTA
NaN
5
477
478
KENTUCKY
ASHLAND
341OHIO
A
UPPER DEVONIAN BLACK SHALES
UDs
NaN
NaN
27770.0
...
0.0
0
AP
G
67.0
6740.0
E
DELTA
NaN
5
478
479
KENTUCKY
ASHLAND
357CLNN
A
LOWER SILURIAN CATARACT/MEDINA GROUP ('CLINTON...
Scm
NaN
NaN
27770.0
...
0.0
1013
AP
G
67.0
6728.0
E
DELTA
NaN
5
479
480
KENTUCKY
AUXIER DBS
355LCKP
A
UPPER SILURIAN LOCKPORT DOLOMITE-KEEFER (BIG S...
Sld
NaN
NaN
NaN
...
0.0
990
AP
G
67.0
6715.0
E
SHELF
NaN
5
480
481
KENTUCKY
AVAWAM DBS
332BGLM
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
NaN
...
0.0
1144
AP
O
67.0
6725.0
E
SHSHF
NaN
5
481
482
KENTUCKY
BALLS FORK DBS
332BGLM
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
4664.0
...
0.0
0
AP
O
67.0
6725.0
E
SHSHF
NaN
5
482
483
KENTUCKY
BANNER SOUTH DBS
332BGLM
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
38172.0
...
0.0
1279
AP
G
67.0
6725.0
E
SHSHF
NaN
5
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
18823
18824
WEST VIRGINIA
TWENTY MILE CREEK EAST
330MSSP
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
723299.0
...
0.0
0
AP
G
67.0
6725.0
E
SHSHF
NaN
5
18824
18825
WEST VIRGINIA
TWENTY MILE CREEK EAST
331BGLM
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
723299.0
...
0.0
0
AP
G
67.0
6725.0
E
SHSHF
NaN
5
18825
18826
WEST VIRGINIA
TWENTY MILE CREEK EAST
331MXON
A
UPPER MISSISSIPPIAN MAUCH CHUNK GROUP AND EQUI...
Mmc
NaN
NaN
723299.0
...
0.0
1091
AP
G
67.0
6725.0
E
DELTA
NaN
5
18826
18827
WEST VIRGINIA
VADIS
330MSSP
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
731953.0
...
0.0
0
AP
O
67.0
6725.0
E
SHSHF
NaN
5
18827
18828
WEST VIRGINIA
VADIS
331BGIJG
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
731953.0
...
0.0
0
AP
O
67.0
6725.0
E
SHSHF
NaN
5
18828
18829
WEST VIRGINIA
VANDALIA
340DVNN
A
UPPER DEVONIAN VENANGO SANDSTONES AND SILTSTONES
Dvs
NaN
NaN
733875.0
...
0.0
0
AP
O
67.0
6718.0
E
SHSHF
NaN
5
18829
18830
WEST VIRGINIA
VANDALIA
340DVNN
A
UPPER DEVONIAN ELK SANDSTONES
Des
NaN
NaN
733875.0
...
0.0
0
AP
O
67.0
6718.0
E
SLBAS
NaN
5
18830
18831
WEST VIRGINIA
VANDALIA
341BLTN
A
UPPER DEVONIAN BRADFORD SANDSTONES AND SILTSTONES
Dbs
NaN
NaN
733875.0
...
0.0
0
AP
O
67.0
6737.0
E
SHSHF
NaN
5
18831
18832
WEST VIRGINIA
VANDALIA
341BNSN
A
UPPER DEVONIAN ELK SANDSTONES
Des
NaN
NaN
733875.0
...
0.0
1106
AP
O
67.0
6737.0
E
SLBAS
NaN
5
18832
18833
WEST VIRGINIA
WALTON (ROCK CREEK)
330MSSP
A
LOWER MISSISSIPPIAN BIG INJUN SANDSTONES
Mbi
NaN
NaN
747543.0
...
0.0
0
AP
O
67.0
6725.0
E
DELTA
NaN
5
18833
18834
WEST VIRGINIA
WALTON (ROCK CREEK)
337BGIJP
A
LOWER MISSISSIPPIAN BIG INJUN SANDSTONES
Mbi
NaN
NaN
747543.0
...
0.0
0
AP
O
67.0
6725.0
E
DELTA
NaN
5
18834
18835
WEST VIRGINIA
WESTON-JANE LEW
330MSSP
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
760959.0
...
0.0
0
AP
O
67.0
6725.0
E
SHSHF
NaN
5
18835
18836
WEST VIRGINIA
WESTON-JANE LEW
331BGIJG
A
UPPER MISSISSIPPIAN GREENBRIER-NEWMAN LIMESTONES
Mgn
NaN
NaN
760959.0
...
0.0
1168
AP
O
67.0
6725.0
E
SHSHF
NaN
5
18836
18837
WEST VIRGINIA
WESTON-JANE LEW
340DVNN
A
UPPER DEVONIAN VENANGO SANDSTONES AND SILTSTONES
Dvs
NaN
NaN
760959.0
...
0.0
0
AP
O
67.0
6718.0
E
SHSHF
NaN
5
18837
18838
WEST VIRGINIA
WESTON-JANE LEW
340DVNN
A
UPPER DEVONIAN ELK SANDSTONES
Des
NaN
NaN
760959.0
...
0.0
0
AP
G
67.0
6718.0
E
SLBAS
NaN
5
18838
18839
WEST VIRGINIA
WESTON-JANE LEW
341BLTNA
R
UPPER DEVONIAN BRADFORD SANDSTONES AND SILTSTONES
Dbs
NaN
NaN
760959.0
...
0.0
0
AP
O
67.0
6737.0
E
SHSHF
NaN
5
18839
18840
WEST VIRGINIA
WESTON-JANE LEW
341BLTNB
R
UPPER DEVONIAN BRADFORD SANDSTONES AND SILTSTONES
Dbs
NaN
NaN
760959.0
...
0.0
0
AP
O
67.0
6737.0
E
SHSHF
NaN
5
18840
18841
WEST VIRGINIA
WESTON-JANE LEW
341BLTNC
R
UPPER DEVONIAN BRADFORD SANDSTONES AND SILTSTONES
Dbs
NaN
NaN
760959.0
...
0.0
0
AP
O
67.0
6737.0
E
SHSHF
NaN
5
18841
18842
WEST VIRGINIA
WESTON-JANE LEW
341BNSN
A
UPPER DEVONIAN ELK SANDSTONES
Des
NaN
NaN
760959.0
...
0.2
1146
AP
G
67.0
6737.0
E
SLBAS
NaN
5
18842
18843
WEST VIRGINIA
WESTON-JANE LEW
341FFTF
A
UPPER DEVONIAN VENANGO SANDSTONES AND SILTSTONES
Dvs
NaN
NaN
760959.0
...
0.0
0
AP
O
67.0
6737.0
E
SHSHF
NaN
5
18843
18844
WEST VIRGINIA
WESTON-JANE LEW
341FFTH
A
UPPER DEVONIAN VENANGO SANDSTONES AND SILTSTONES
Dvs
NaN
NaN
760959.0
...
0.1
1156
AP
O
67.0
6737.0
E
SHSHF
NaN
5
18844
18845
WEST VIRGINIA
WESTON-JANE LEW
341FRTH
A
UPPER DEVONIAN VENANGO SANDSTONES AND SILTSTONES
Dvs
NaN
NaN
760959.0
...
0.0
0
AP
O
67.0
6737.0
E
SHSHF
NaN
5
18845
18846
WEST VIRGINIA
WESTON-JANE LEW
341GNTZ
A
UPPER DEVONIAN VENANGO SANDSTONES AND SILTSTONES
Dvs
NaN
NaN
760959.0
...
0.0
0
AP
O
67.0
6737.0
E
SHSHF
NaN
5
18846
18847
WEST VIRGINIA
WESTON-JANE LEW
341SPCLL
R
UPPER DEVONIAN BRADFORD SANDSTONES AND SILTSTONES
Dbs
NaN
NaN
760959.0
...
0.0
0
AP
O
67.0
6737.0
E
SHSHF
NaN
5
18847
18848
WEST VIRGINIA
WESTON-JANE LEW
341SPCLU
R
UPPER DEVONIAN BRADFORD SANDSTONES AND SILTSTONES
Dbs
NaN
NaN
760959.0
...
0.0
0
AP
O
67.0
6737.0
E
SHSHF
NaN
5
18848
18849
WEST VIRGINIA
WILBUR
330MSSP
A
LOWER MISSISSIPPIAN BIG INJUN SANDSTONES
Mbi
NaN
NaN
767795.0
...
0.0
0
AP
O
67.0
6725.0
E
DELTA
NaN
5
18849
18850
WEST VIRGINIA
WILBUR
337BGIJU
A
LOWER MISSISSIPPIAN BIG INJUN SANDSTONES
Mbi
NaN
NaN
767795.0
...
0.0
1429
AP
G
67.0
6725.0
E
DELTA
NaN
5
18850
18851
WEST VIRGINIA
WILBUR
340DVNN
A
UPPER DEVONIAN ELK SANDSTONES
Des
NaN
NaN
767795.0
...
0.0
0
AP
G
67.0
6718.0
E
SLBAS
NaN
5
18851
18852
WEST VIRGINIA
WILBUR
341BNSN
A
UPPER DEVONIAN ELK SANDSTONES
Des
NaN
NaN
767795.0
...
0.0
0
AP
G
67.0
6737.0
E
SLBAS
NaN
5
18852
18853
WEST VIRGINIA
WILBUR
341RILY
A
UPPER DEVONIAN BRADFORD SANDSTONES AND SILTSTONES
Dbs
NaN
NaN
767795.0
...
0.0
0
AP
G
67.0
6737.0
E
SHSHF
NaN
5
2633 rows × 187 columns
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
Lets make a histogram of average permeability (In column CN), use column name not CN Google this
In [22]:
pd.DataFrame.hist(table,"AVPERM")
Out[22]:
array([[<matplotlib.axes._subplots.AxesSubplot object at 0x113144710>]], dtype=object)
/Users/kishanramachandran/anaconda/lib/python3.5/site-packages/matplotlib/font_manager.py:273: UserWarning: Matplotlib is building the font cache using fc-list. This may take a moment.
warnings.warn('Matplotlib is building the font cache using fc-list. This may take a moment.')
/Users/kishanramachandran/anaconda/lib/python3.5/site-packages/matplotlib/font_manager.py:273: UserWarning: Matplotlib is building the font cache using fc-list. This may take a moment.
warnings.warn('Matplotlib is building the font cache using fc-list. This may take a moment.')
Content source: texaspse/blog
Similar notebooks: