Graph Transformation Example¶
Data in a table form can be transformed into numerous different formats using the class pyMez.Code.DataHandlers.GraphModels.TableGraph. The abstract data model is a table with column names.
Examples of Formats¶
| Excel File |
| Csv File |
| Hdf File |
| Html File |
| Json File |
| Matlab File |
| Open Office File |
| XML File |
Import needed modules¶
In [1]:
from pyMez.Code.DataHandlers.GraphModels import *
In [2]:
# create the graph
graph=TableGraph()
In [3]:
# now we have access to the folowing data formats
graph.node_names
Out[3]:
In [4]:
# to visualize the graph use the show method
graph.show()
Out[4]:
In [5]:
# if we want to open an ascii data table or subclass we open the schema and then open the file
schema=read_schema(os.path.join(os.getcwd(),"./TableGraph_Files/Line_4909_WR15_Wave_Parameters_20180313_003.schema"))
ascii_table=AsciiDataTable(os.path.join(os.getcwd(),"./TableGraph_Files/Line_4909_WR15_Wave_Parameters_20180313_003.w2p"),
**schema)
In [6]:
graph.set_state(node_name="AsciiDataTable",node_data=ascii_table)
In [7]:
# now if you want a pandas data frame just move to that node
graph.move_to_node("DataFrame")
In [8]:
#now dataframe is just
pandas_dataframe=graph.data
In [9]:
pandas_dataframe[0:10]
Out[9]:
In [10]:
# if we want to transform to json string
graph.move_to_node("JsonString")
In [11]:
json=graph.data
In [12]:
# if we would like to transform it to all possible data types -the xslx and ods require a confirmation
# first change the working directory and now all files will be put in the folder
os.chdir("./TableGraph_Files")
visit_all_nodes(graph)