Arithmetic and aligning DataFrames with same columns, different index levels

by

Use the DataFrame div method and pass matchkey for the multi-index you want to broadcast across:

From the documentation for div:

level : int or name
    Broadcast across a level, matching Index values on the
    passed MultiIndex level

In [39]: concentration.div(weight, level="Land Use")
Out[39]:
                                    1E          1N           1S           2
Land Use    Parameter
Airfield    BOD5 (mg/l)       0.818004    5.198238     3.668831    2.697970
            Ortho P (mg/l)    0.003914    0.044053     0.016234    0.005076
            TSS (mg/l)        3.469667  505.286344    13.993506    0.464467
            Zn (mg/l)         0.001957    0.044053     0.000804    0.002538
Commercial  BOD5 (mg/l)      72.000000    0.245892          NaN    2.957746
            Cu (mg/l)         0.087400    0.000431          NaN    0.003662
            O&G (mg/l)       77.000000    0.745305          NaN    2.469484
Open Space  TSS (mg/l)      463.750000  602.000000  6045.000000  367.500000
            Zn (mg/l)        15.875000    1.380000    66.000000   17.500000
Parking Lot BOD5 (mg/l)       2.800000    0.129961    10.329365   18.654971
            O&G (mg/l)        3.090909    0.289883     5.345238   10.994152
Rooftops    BOD5 (mg/l)       1.666667   35.714286   661.176471  103.333333

More Related Contents:

  1. cartesian product in pandas
  2. What are the ‘levels’, ‘keys’, and names arguments for in Pandas’ concat function?
  3. Keep other columns when doing groupby
  4. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  5. Convert the string 2.90K to 2900 or 5.2M to 5200000 in pandas dataframe
  6. What does `ValueError: cannot reindex from a duplicate axis` mean?
  7. Conditionally fill column values based on another columns value in pandas
  8. Search for String in all Pandas DataFrame columns and filter
  9. Plot a horizontal line on a given plot
  10. Normalize columns of a dataframe
  11. Rename result columns from Pandas aggregation (“FutureWarning: using a dict with renaming is deprecated”)
  12. Python Pandas, write DataFrame to fixed-width file (to_fwf?)
  13. “unstack” a pandas column containing lists into multiple rows [duplicate]
  14. How to check whether a pandas DataFrame is empty?
  15. Python pandas Filtering out nan from a data selection of a column of strings
  16. Copy pandas dataframe to excel using openpyxl
  17. Finding label location in a DataFrame Index
  18. pandas merging based on a timestamp which do not match exactly
  19. pandas fill missing dates in time series
  20. How to drop unique rows in a pandas dataframe?
  21. How to deal with NaN values when plotting a boxplot
  22. Pandas How to filter a Series
  23. Querying for NaN and other names in Pandas
  24. Pandas: drop columns with all NaN’s
  25. Getting vertical gridlines to appear in line plot in matplotlib
  26. How to convert R dataframe back to Pandas using rpy2?
  27. How can I create the minimum size executable with pyinstaller?
  28. dataframe to long format
  29. How to unpack a Series of tuples in Pandas?
  30. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?

Leave a Comment