This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
tutorials:python_quick_reference [2021/05/13 16:03] marcus.williams [Python Debugger (PDB)] |
tutorials:python_quick_reference [2021/08/03 16:07] marcus.williams [Data interrogation] |
||
---|---|---|---|
Line 105: | Line 105: | ||
<code> | <code> | ||
pt_structure = pd.pivot_table(df_structure, | pt_structure = pd.pivot_table(df_structure, | ||
- | 'OBJECTID', | + | values='OBJECTID', |
index=['propType'], | index=['propType'], | ||
columns=['strucType'], | columns=['strucType'], | ||
margins=True, | margins=True, | ||
- | aggfunc=len) | + | aggfunc=np.sum) |
</code> | </code> | ||
[[http://pandas.pydata.org/pandas-docs/stable/generated/pandas.pivot_table.html#pandas.pivot_table|ref]] | | [[http://pandas.pydata.org/pandas-docs/stable/generated/pandas.pivot_table.html#pandas.pivot_table|ref]] | | ||
Line 580: | Line 580: | ||
<code> | <code> | ||
set([1,2,3]) - set([2,3,4]) | set([1,2,3]) - set([2,3,4]) | ||
+ | </code> | ||
+ | |||
+ | See other set [[https://www.w3schools.com/python/python_ref_set.asp|operations]] including: | ||
+ | <code> | ||
+ | set1.union(set2) | ||
+ | set1.intersection(set2) | ||
</code> | </code> | ||
==== T ==== | ==== T ==== |