barge | 🐳 Docker Compose files for the full Ocean Protocol stack | Continuous Deployment library

I have deeply nested data that looks like the following. The data may look needlessly nested, but I've removed unimportant data to reduce some clutter.

So basically I am making an online restaurant website where you can order food. I am going to make cards for each food item listed. Right now, I am making buttons that add and subtract the number of each item the customer wants to purchase.

I know there is a few questions on SO regarding the conversion of JSON file to a pandas df but nothing is working. Specifically, the JSON requests the current days information. I'm trying to return the tabular structure that corresponds with Data but I'm only getting the first dict object.

I'll list the current attempts and the resulting outputs below.

I have 2 lists from an API, and I want to have one be the keys and the other be the values for a dictionary. The Keys and Values are not even, most keys have multiple values assigned to them; but every time I try to assign the values to the specific keys that the API gave me, I cannot figure out how to align the keys and values together and add it to the dictionary.

I have converted the following file into a pandas df:

https://www.fca.org.uk/publication/data/position-limits-contract-names-vpc.xlsx

I have converted the relevant rows (for myself) into a dict. The dict is of the form {principal: [spot, aggregate, set(product codes)]}. I have used the following code to convert it into this dict:

I have 2 two-dimensional matrices which I try to combine into 1. There are 3 common sets in each matrix, voyages barges and category's. I have an binary matrix which assigns barges to voyages, and I have a matrix which states the capacity of different categorys of cargo per barge. Now what I try to create is a table which gives the capacity per voyage based on which barge is assigned to it. I made some example data, my real data is tables and data frames in R;

table 1: capacity of category c for barge b

table 2: = 1 if barge b goes on voyage v

Now based on these 2 tables I want to get a table, which gives me the cap of each voyage, as follows;

table 3: output table

table 1 and 2 are both of type matrix in R

After I work the data I import it in python, so if someone knows how to do it there instead of in R, that would work fine as well.

Regards

So I have a script that I need to read to the caller that is about 30 mins long.

Along the way the customer may interrupt the read and ask a question.

The callers question needs to be addressed, and then the read needs to continue from just before where it was interrupted.

so to track progress I store a session variable with a step number.

I say a sentence or two of the script. | I listen with barge true

then I redirect to the next section of the script.

this creates a pause waiting for caller response after the say and prior to the redirect.

UGH.... so I create a twilio function that checks the step and adds steps above the current step. the result looks like this

I based my script largely off of the chitown88 answer of this question. My script is meant to pull lock (i.e. lock and dam) data from XMLs on the Army Corps of Engineers website using BeautifulSoup. From that data it creates a table using Pandas, and then creates a list with each lock getting its own table. Finally, it writes the tables into separate excel sheets. It works perfectly fine. However, now I'm asking for assistance summing the 'Number of Barges' column on each sheet.

I would like to create a 'Total' row at the bottom with the 'Number of Barges' column being the only one that is summed. Both of my attempts did not put the sum at the bottom. Rather, it just repeated each value from that column in a new row.

(1) I have tried

This error is apparently stemming from xlsxwriter. I'm not sure on what line of my code it's coming from because my editor Visual Studio 2019 crashes every time I try to debug. But, I get this error on a laptop while on a VPN and remote desktop connection. If I run the same code from my remote machine I don't get the error. The error doesn't seem to affect the output, though, because the script finishes and saves successfully. But, how do I get rid of this error?

My Code: