How to use pfs from_dataframe

[Hendrik1987]

I have a pfs template with a dummy point output of one point and try to update this with a list of points from a dataframe df2.

The output in the template looks like this:

I can update the number of points

and create pfs section of points from my dataframe:

However, I can't figure out how to replace the existing OUTPUT_3.POINT_1 pfs section with the newly created points pfs section.

I have tried:

1. Out.OUTPUT_3 = points, but then I am obviously loosing the header.
2. Out.OUTPUT_3.POINT_1 = points, but the I get a non-desired indent.
3. Out.OUTPUT_3.POINT_1.update(points) but it does not return anything.

Furthermore, I don't fully get

• Why is points a PfsSection, albeit it is multiple sections on top of each other?
• On which PfsSection should I call the .from_dataframe?

I have not managed to find the answers in the docs or example. Hence, thanks for any hints!

[jsmariegaard]

Your points object is a PfsSection of PfsSections. It behaves like a dictionary, hence you should be able to do something like this:

for n, p in points.items():
    Out.OUTPUT_3[n] = p

.from_dataframe() is class method that returns a PfsSection.

sct = mikeio.PfsSection.from_dataframe(df)

Does that answer your questions?

[Hendrik1987]

.from_dataframe() is class method that returns a PfsSection.

Got it. So my code would probably be cleaner like this.

points = mikeio.PfsSection.from_dataframe(df2, 'POINT_')

Your points object is a PfsSection of PfsSections. It behaves like a dictionary, hence you should be able to do something like this: [...]

Updated:

Yes this works:

for n, p in points.items():
    Out.OUTPUT_3[n] = p

Equally works to go via a dict:

dic = Out.OUTPUT_3.to_dict()
dic.update(points.to_dict())
Out.OUTPUT_3 = mikeio.pfs.PfsSection(dic)

The latter is a bit long, but from the documentation I did expect .update to do something similar. But this does not seem to work - maybe it's not intended?

Out.OUTPUT_3.update(points)

Also I had to remember to do

df2.index = df2.index+1

The key is build from prefix and index here and it seems that the key must be 1-based, otherwise the .to_dataframe() fails (and presumably the model run, too).

Finally, I wonder if a .update_from_dataframe() would be nice to wrap your solution above.

Thanks again!

[jsmariegaard]

I am not sure why you're trying to access OUTPUT_3[0]. OUTPUT_3 is a PfsSection dict-like structure and the keys (including subsections) are of str type.

The intention with

for n, p in points.items():
    Out.OUTPUT_3[n] = p

was to get key-value pairs like this:

POINT_1, [PfsSection]
POINT_2, [PfsSection]
...

But the code is could be wrong - I did not test.

[Hendrik1987]

No, that was me reading code suggestion too fast. n triggered for me that it is an int (like with enumerate), but of course it is the key, looping through points. Will give it a go.

[Hendrik1987]

Your solution works. Updated my comment above accordingly and accepted your answer. Thanks!