Skip to content

Instantly share code, notes, and snippets.

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