What have you tried so far? what is your specific problem?, we are more inclined towards helping you with specific coding problems rather than doing your work for you.
You have provided working code, which is an example of generate sankey network from example data.
you seem to be asking us to adapt the code to work on data you have, that you havent shared. This is unreasonable.
You could perhaps provide a REPRoducible EXample (reprex) where the data is a reasonable sample of yours, given that that seems to be the point of difficulry for you.
A reprex makes it much easier for others to understand your issue and figure out how to help.
If you've never heard of a reprex before, you might want to start by reading this FAQ: