Skip to content

Instantly share code, notes, and snippets.

@jivens
Created February 7, 2017 13:34
Show Gist options
  • Save jivens/5601eb6ba22b48bb5e26bdd42d2b6bf7 to your computer and use it in GitHub Desktop.
Save jivens/5601eb6ba22b48bb5e26bdd42d2b6bf7 to your computer and use it in GitHub Desktop.
read in table as a dataframe using pandas
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
data3 = pd.read_table('/Users/amyfou/Downloads/path_data.tsv',sep='\t')
data3
Event Trigger Trigger Tags Argument Argument Type Path Path Length Pattern Frequency
0 Gene_expression trigger = [lemma='expression' & tag='NN'] 'NN' Theme Protein >nn 1 382
1 Gene_expression trigger = [lemma='expression' & tag='NN'] 'NN' Theme Protein >prep_of 1 201
2 Gene_expression trigger = [lemma='expression' & tag='NN'] 'NN' Theme Protein >prep_of >nn 2 122
3 Transcription trigger = [lemma='transcription' & tag='NN'] 'NN' Theme Protein >nn 1 121
4 Gene_expression trigger = [lemma='production' & tag='NN'] 'NN' Theme Protein >nn 1 91
5 Phosphorylation trigger = [lemma='phosphorylation' & tag='NN'] 'NN' Theme Protein >prep_of 1 46
6 Phosphorylation trigger = [lemma='phosphorylation' & tag='NN'] 'NN' Site Entity >nn 1 45
7 Positive_regulation trigger = [lemma='induce' & tag='VBD'] 'VBD' Theme Gene_expression >dobj 1 41
8 Positive_regulation trigger = [lemma='induction' & tag='NN'] 'NN' Theme Protein >prep_of 1 39
9 Positive_regulation trigger = [lemma='activation' & tag='NN'] 'NN' Theme Protein >prep_of >nn 2 37
10 Transcription trigger = [lemma='expression' & tag='NN'] 'NN' Theme Protein >prep_of >nn 2 37
11 Positive_regulation trigger = [lemma='induction' & tag='NN'] 'NN' Theme Protein >nn 1 35
12 Binding trigger = [lemma='binding' & tag='NN'] 'NN' Theme Protein >prep_of 1 33
13 Localization trigger = [lemma='secretion' & tag='NN'] 'NN' Theme Protein >nn 1 33
14 Gene_expression trigger = [lemma='express' & tag='VBN'] 'VBN' Theme Protein >nsubjpass 1 32
15 Positive_regulation trigger = [lemma='activation' & tag='NN'] 'NN' Theme Protein >nn 1 32
16 Regulation trigger = [lemma='regulation' & tag='NN'] 'NN' Theme Gene_expression >prep_of 1 31
17 Transcription trigger = [lemma='expression' & tag='NN'] 'NN' Theme Protein >nn 1 31
18 Transcription trigger = [lemma='transcription' & tag='NN'] 'NN' Theme Protein >prep_of >nn 2 31
19 Localization trigger = [lemma='translocation' & tag='NN'] 'NN' ToLoc Entity >amod 1 30
20 Phosphorylation trigger = [lemma='phosphorylation' & tag='NN'] 'NN' Theme Protein >nn 1 30
21 Positive_regulation trigger = [lemma='induction' & tag='NN'] 'NN' Theme Protein >prep_of >nn 2 30
22 Positive_regulation trigger = [lemma='activation' & tag='NN'] 'NN' Theme Protein >prep_of 1 30
23 Gene_expression trigger = [lemma='production' & tag='NN'] 'NN' Theme Protein >prep_of 1 26
24 Positive_regulation trigger = [lemma='induce' & tag='VBD'] 'VBD' Cause Protein >nsubj 1 26
25 Regulation trigger = [lemma='regulate' & tag='VBN'] 'VBN' Theme Gene_expression >nsubjpass 1 25
26 Positive_regulation trigger = [lemma='induction' & tag='NN'] 'NN' Theme Gene_expression >prep_of 1 24
27 Negative_regulation trigger = [lemma='inhibit' & tag='VBD'] 'VBD' Theme Positive_regulation >dobj 1 23
28 Gene_expression trigger = [lemma='overexpression' & tag='NN'] 'NN' Theme Protein >prep_of 1 22
29 Protein_catabolism trigger = [lemma='degradation' & tag='NN'] 'NN' Theme Protein >prep_of 1 22
... ... ... ... ... ... ... ... ...
4996 Transcription trigger = [lemma='transcription' & tag='NN'] 'NN' Theme Protein >prep_of >dep 2 1
4997 Transcription trigger = [lemma='mrna' & tag='NN'] [lemma='le... 'NN' 'NNS' Theme Protein >prep_for >nn 2 1
4998 Transcription trigger = [lemma='transcription' & tag='NN'] 'NN' Theme Protein <prep_with >nsubjpass >prep_of >prep_on >nn 5 1
4999 Transcription trigger = [lemma='transcriptional' & tag='JJ']... 'JJ' 'NN' Theme Protein <prep_at >nsubjpass >dep >nn 4 1
5000 Transcription trigger = [lemma='transcriptional' & tag='JJ'] 'JJ' Theme Protein <amod >appos 2 1
5001 Transcription trigger = [lemma='transcription' & tag='NN'] 'NN' Theme Protein <prep_of <dobj <xcomp >prep_including >nn 5 1
5002 Transcription trigger = [lemma='at' & tag='IN'] [lemma='the'... 'IN' 'DT' 'NN' 'IN' 'NN' Theme Protein <prep_at >nsubj >nn 3 1
5003 Transcription trigger = [lemma='expression' & tag='NN'] 'NN' Theme Protein <dobj >prep_together_with >nn 3 1
5004 Transcription trigger = [lemma='transcript' & tag='NN'] [lem... 'NN' 'NNS' Theme Protein >prep_of >nn 2 1
5005 Transcription trigger = [lemma='production' & tag='NN'] 'NN' Theme Protein <prep_in <appos <nsubj 3 1
5006 Transcription trigger = [lemma='production' & tag='NN'] 'NN' Theme Protein <dep >amod >dep 3 1
5007 Transcription trigger = [lemma='transcription' & tag='NN'] 'NN' Theme Protein <conj_and >amod >prepc_without >xcomp 4 1
5008 Transcription trigger = [lemma='mrna' & tag='NN'] [lemma='ex... 'NN' 'NN' Theme Protein <prep_of >prep_of >appos 3 1
5009 Transcription trigger = [lemma='expression' & tag='NN'] 'NN' Theme Protein <appos 1 1
5010 Transcription trigger = [lemma='transcript' & tag='NN'] 'NN' Theme Protein <nn <prep_with >nsubjpass 3 1
5011 Transcription trigger = [lemma='transcriptional' & tag='JJ'] 'JJ' Theme Protein <amod <prep_at >prep_on 3 1
5012 Transcription trigger = [lemma='expression' & tag='NN'] 'NN' Theme Protein >conj_negcc >nn 2 1
5013 Transcription trigger = [lemma='transcript' & tag='NN'] 'NN' Theme Protein >nn 1 1
5014 Transcription trigger = [lemma='transcription' & tag='NN'] 'NN' Theme Protein >prep_of >prep_of >dep >appos 4 1
5015 Transcription trigger = [lemma='transcription' & tag='NN'] 'NN' Theme Protein <dobj >iobj >appos 3 1
5016 Transcription trigger = [lemma='transcription' & tag='NN'] 'NN' Theme Protein >conj_negcc >prep_of 2 1
5017 Transcription trigger = [lemma='concentration' & tag='NN'] 'NN' Theme Protein >prep_of >nn 2 1
5018 Transcription trigger = [lemma='transcription' & tag='NN'] 'NN' Theme Protein <conj_and >dep >xcomp 3 1
5019 Transcription trigger = [lemma='level' & tag='NNS'] 'NNS' Theme Protein <conj_and 1 1
5020 Transcription trigger = [lemma='expression' & tag='NN'] [lem... 'NN' 'NN' Theme Protein >prep_of >nn 2 1
5021 Transcription trigger = [lemma='expression' & tag='NN'] 'NN' Theme Protein <prep_to >nsubj >nn 3 1
5022 Transcription trigger = [lemma='induction' & tag='NN'] 'NN' Theme Protein <dep 1 1
5023 Transcription trigger = [lemma='level' & tag='NNS'] 'NNS' Theme Protein <prep_in <prep_than <amod 3 1
5024 Transcription trigger = [lemma='expression' & tag='NN'] 'NN' Theme Protein <nn 1 1
5025 Transcription trigger = [lemma='level' & tag='NNS'] 'NNS' Theme Protein >conj_or >nn 2 1
5026 rows × 8 columns
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment