COA | Openstack Foundation Openstack Certified Administrator exam | Platform As A Service library

I am trying to run a loop in a web scraping script that uses Beautiful Soup to extract data from this Page. The loop will loop through each div tag and extract 4 different pieces of information. It searches a h3, a div, and 2 span tags. But when I add the ".text" option I get errors from the 'date,' 'soldprice,' and 'shippingprice.' The error says:

I need to prepare my data for modelling and I want to create a dataframe with 0-1 values for the columns. I have a list with different columns which i want to one hot encode into a dataframe.

I have data from multiple suppliers which I wish to compare. The data shown in the image below has been previously transformed via a series of steps using power query. The final step was to pivot the Supplier column (in this example consisting of X,Y,Z) so that these new columns can be compared and the maximum value is returned.

How can I compare the values in columns X, Y and Z to do this? Importantly, X Y and Z arent necessarily the only suppliers. If I Add Say A as a new supplier to the original data, a new column A will be generated and I wish to include this in the comparison so that at column at the end outputs the highest value found for each row. So reading from the top down it would read in this example: 3,3,1,1,5,0.04,10 etc.

Thanks

Link to file https://onedrive.live.com/?authkey=%21AE_6NgN3hnS6MpA&id=8BA0D02D4869CBCA%21763&cid=8BA0D02D4869CBCA

M Code:

Background: The table below contains example data from relevant documents (the names of documents are MSDS, RMQ, COA, Technical Data sheet) for materials A,B,C etc. The information from these documents includes the date, Heavy Metal impurities and Residual Solvent impurities and their amount in ppm (parts per million).

Using power query I have sorted this data so that the 2 tables shown in the image below are produced.

These containing the highest amounts of heavy metals (blue) and residual solvents (yellow) found across the documentation as well as source of the document containing this value. To replicate the spreadsheet I have provided the (quite extensive) M code at the bottom. Very Briefly though for this problem; "Heavy Metals" and "Residual Solvents" are phrases used as delimiters to split the data accordingly.

Minor Problem: Although pleased with how the table functions, I didn't feel that the 'splitting of a split column' (see M code) is an entirely satisfactory solution to separate the data. Subsequently I've realised that If a cell were to accidently not include "Heavy Metals" as a delimiter the logic would cause the Residual Solvent data for this cell to be lost (as is the case for Cell 4E (Material C, technical data Sheet)).

I may just insist to those using this spreadsheet to ensure these phrases are always present however I wanted to ask here to see if anyone had any clever alternatives to the M Code provided so that although the Heavy Metals may be missing without the delimiter (or if spelled incorreclty), the Residual Solvents are still pulled through.

I appreciate that this is rather a tasking job for someone to look at, and fortunately it is a relatively minor issue so any advice would just be a bonus. I also just through it was quite quite interesting to show how power query can be used to split seemingly complex data within a cell. Also please note that the Data in the table is 'messy' to test if this causes any problems.

M Code: This is the Code for just the Residual Solvents Table. Power query splits the data into heavy Metals and Residual Solvents and then depending on the table removes the appropriate columns.

(mask extension - backendlayout) - but only the image will be display. The same code already works with a menu. But without the menu it will not display my TITLE from site property. The field name is correct!

I have a menu (HMENU with special = updated) that gives me the latest sub and sub-sub pages from 3 categories. The page structure looks like this in the backend:

In addition to the title, I would like to output the name of the respective category (the parent level-1 page).

This is my TypoScript attempt:

I need to create two dataframes to operate my data and I have thinked about doing it with pandas.

This is the provided data:

I have a pandas column that contains data like this:

I want to format the date with typoscript: