Skip to content

Instantly share code, notes, and snippets.

@vcloitre
Created June 30, 2015 16:51
Show Gist options
  • Save vcloitre/b3b55df38568708be4a6 to your computer and use it in GitHub Desktop.
Save vcloitre/b3b55df38568708be4a6 to your computer and use it in GitHub Desktop.
Metrics change data structure
>>> import cymetric as cym
>>> db = cym.dbopen('deploy_thr_output.sqlite')
>>> evaler = cym.Evaluator(db, write=False)
>>> resources = evaler.eval('Resources')
>>> resources['Quantity']
0 400
1 400
2 400
3 400
4 400
5 400
6 400
7 400
8 400
9 400
10 400
11 400
12 400
13 400
14 400
15 400
16 400
17 400
18 400
19 400
20 400
21 400
22 400
23 400
24 400
25 400
26 400
27 400
28 400
29 400
...
13710 400
13711 400
13712 400
13713 400
13714 400
13715 400
13716 400
13717 400
13718 400
13719 400
13720 400
13721 400
13722 400
13723 400
13724 400
13725 400
13726 400
13727 400
13728 400
13729 400
13730 400
13731 400
13732 400
13733 400
13734 400
13735 400
13736 400
13737 400
13738 400
13739 400
Name: Quantity, dtype: float64
>>> materials = evaler.eval('Materials')
>>> resources['Quantity']
SimId QualId ResourceId ObjId TimeCreated Units
b6e3bf1d-08ab-4ab5-bc8b-4dc62ef441b9 4 1922 1921 10 kg 400
1924 1922 10 kg 400
1926 1923 10 kg 400
1928 1924 10 kg 400
1930 1925 10 kg 400
1932 1926 10 kg 400
1934 1927 10 kg 400
1936 1928 10 kg 400
1938 1929 10 kg 400
1940 1930 10 kg 400
1942 1931 10 kg 400
1944 1932 10 kg 400
1946 1933 10 kg 400
1948 1934 10 kg 400
1950 1935 10 kg 400
1952 1936 10 kg 400
1954 1937 10 kg 400
1956 1938 10 kg 400
1958 1939 10 kg 400
1960 1940 10 kg 400
1962 1941 10 kg 400
1964 1942 10 kg 400
1966 1943 10 kg 400
1968 1944 10 kg 400
1970 1945 10 kg 400
1972 1946 10 kg 400
1974 1947 10 kg 400
1976 1948 10 kg 400
1978 1949 10 kg 400
1980 1950 10 kg 400
...
63417 49706 595 kg 400
63419 49707 595 kg 400
63421 49708 595 kg 400
63423 49709 595 kg 400
63425 49710 595 kg 400
63427 49711 595 kg 400
63429 49712 595 kg 400
63431 49713 595 kg 400
63433 49714 595 kg 400
63435 49715 595 kg 400
63437 49716 595 kg 400
63439 49717 595 kg 400
63441 49718 595 kg 400
63443 49719 595 kg 400
63445 49720 595 kg 400
63447 49721 595 kg 400
63449 49722 595 kg 400
63451 49723 595 kg 400
63453 49724 595 kg 400
63455 49725 595 kg 400
63457 49726 595 kg 400
63459 49727 595 kg 400
63461 49728 595 kg 400
63463 49729 595 kg 400
63465 49730 595 kg 400
63467 49731 595 kg 400
63469 49732 595 kg 400
63471 49733 595 kg 400
63473 49734 595 kg 400
63475 49735 595 kg 400
Name: Quantity, dtype: float64
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment