surgical | An open-source simulator for surgical tools | Machine Learning library

I would like to reshape the table with patient information. I have tried xtabs from base R and acast from reshape2, but couldn't get the results. My table looks something like this:

As you can see some patients might have surgery some don't, in this situation it is not even mentioned under the patient's name. And the number which is next to id 0021 and 0154 is the total number of quantity and total price for that patient, this information is not needed in the new table. I think totals can be easily calculated later. The final table should look like this:

So, the function has to fill missed variables with 0, and have to be vertical.

I did linear regression analysis between the response variable(y) and predictor variables in the surgical data set considering pindex as a confounding variable. I aim to plot the response variable(y) against the experimentally determined values of the predictor variables and to this end, I am Successful. However, could not able to indicate the estimated regression and p-value in the ggplot2. In the code below, trying to do the analysis and the plot. It would be much appreciated if someone could show me how to indicate the estimated regression and p-values inside the ggplot2.

I am trying to visualize surgical procedures before and after Covid-19:

As you can see, I have a geom_rect() colored differently than the geom_point().

I want the blue color and fill in the geom_rect() to be semi-transparent, something like fill = alpha("#2C77BF", .5)). However, when using the script below, the alpha-part does not work.

How can I obtain the semi-transparency of geom_rect() for a color different from those specified for geom_point()?

learning responsive design with css grid. I have set some general layout for the desktop and that worked fine but I didn't manage to make the change for the phone. What I want to do is set all the pictures under each other. Any idea how to do that? I appreciate any help. You can find the snippet bellow.

I have this plot visualizing surgical procedures before and after Covid-19.

The time span I am looking at is between 2017-01-02 and 2020-12-31 (yyyy-mm-dd). However, the plot automatically includes Dec2016 and March2021. I want to omit these two breaks.

First

Question: how can I make an x-axis more readable when it is based on +200 consecutive weeks? I was planning to break the x-axis into months. The problem is that the 1st day of a week does not necessarily match the 1st day of the month. Therefore, there is an overlap I don't know how to handle (two successive months placed in the same week).

I am visualizing surgical procedures before and after Covid-19.

The x-axis correspond to consecutive weeks since monday 2017-01-02 (yyyy-mm-dd), and ranges 1 - 209. Each geom_point() correspond to number of surgical procedures per week.

Normally, I would simply break the x-axis into smaller ranges, e.g. x-axis breaks corresponding to 3 months. Unfortunately, as b$cons_week count each consecutive monday passed since 2017-01-02, it does not necessarily correspond to "month breaks" (as the 1st day of a month is not necessarily coinciding with 1st day of the week). Therefore, I have no idea how to break the x-axis.

My data look like this

I am trying to make a website well responsive (in snippet). It is not behaving as I would expect though. From some reason at the width from 600 to 900 (or ipad), the pictures form a weird shape. I don't know what is it caused by. What I would expect to happen is that the pictures would form 3 rows with 2 pictures each and one picture at the bottom. Any idea how to fix that?

As you can see in the snippet bellow. I am trying to fit all the content but it is going out on the website, especially on the small devices (iphone x for example), parts of the content are not there. Any idea how to fix this? Thanks for any help as I dont know how to do this but presumebly something with flexbox

The purpose

For university research I try to process data of clinical studies publicly available here.

For reproducibility, I would like to directly use the downloaded JSON or XML files (and not to retrieve the data via the web API, which has been described: how-to-get-data-out-of-nested-xml-structure).

Update 1: The structure of the JSON file is published here

Update 2: The structure of the XML file is published here

I think tidyjson::read_json and tidyjson::spread_all do the trick! See the answer section.

What I need

For my workflow, I need to convert the data to data.frames (tidy data.frames would be even better). I prefer JSON, hoever, if there was a solution for the XML format I would be very glad.

Test data

A nested list that I generated of one of the downloaded JSON files with jsonlite::fromJSON("NCT0455805.json")