remodel | Data and class remodeling library

Excuse me for the length of the title please but this is a pretty specific question. I'm currently simulating a launch of a rocket to mars in the 2022 launch window and I noticed that my rocket is a far distance away from Mars, even though it's traveling in the right direction. After simplifying my code to narrow down the problem, I simply plotted the orbits of the Earth and Mars (Using data from NASA's SPICE library) and propagated the position and velocity given to me by the lambert solver I implemented (Universal variables) to plot the final orbit of the rocket.

I'm only letting the Sun's gravity effect the rocket, not the Earth or Mars, to minimize my problem space. Yet even though I've simplified my problem so far, the intersection between Mars' and my rocket's orbits happens well before the time of flight has been simulated all the way, and the minimum distance between the two bodies is more than a million kilometers at all times.

That being said, something must be wrong but I cannot find the problem. I've made sure the lambert solver code I copied is correct by comparing it to Dario Izzo's method and both gave the same results. Furthermore, I've also checked that my orbit propagator works by propagating Mars' and the Earth's orbits and comparing those ellipses to the data from SPICE.

In conclusion, I assume this must be a stupid little mistake I made somewhere, but cannot find because I lack experience in this field. Thank you for any help! :)

This is the JupyterLab notebook I used:

I'm currently building a test, and it seems that after the second and third test, the beforeEach is not getting the information that I need and is telling me that I'm having the following issue:

I have the list which contains 50 sample IDs. The part of the list looks like the following:

Let’s say I have 6 databases, multiple industries, mostly similar schema.

Currently we have dozens of excel files that connect to each DB and query live data (work orders, invoices etc).

As I understand. Creating a separate DW database would be of benefit performance wise, but also when remodelled, would eliminate complex joins currently required by our QA people.

Would it stand to reason, that I would have a denormalized table, called ‘WorkOrder’ which was also a merger of all work orders across 5-6 systems? How would I handle the primary keys of each workorder, when they overlap? I assume a distinct column for each with a unique prefix to designate the origin database?

Should the workorder table contain only common fields, or would all fields make more sense, nulling out those fields where data didn’t exist in the original?

This denormalized table would be easier to query from the QA standpoint, no doubt. But seems to contradict what I’ve read about DW star or snowflake modelling with facts etc?!?

It’s very likely I just don’t get the fundamentals of data warehousing either :)

I have been given an output in R, and I wish to copy and paste the output into other Microsoft applications. However, each line is numbered. How do I remove the numbers?

For example:

I need to extract the journal titles from a bibliography list. The titles are all within quotation marks. So is there a way to ask R to extract all text that is within parenthesis?

I have read the list into R as a text file:

"data <- readLines("Publications _ CCDM.txt")"

here are a few lines from the list:

Andronis, C.E., Hane, J., Bringans, S., Hardy, G., Jacques, S., Lipscombe, R., Tan, K-C. (2020). “Gene validation and remodelling using proteogenomics of Phytophthora cinnamomi, the causal agent of Dieback.” bioRxiv. DOI: https://doi.org/10.1101/2020.10.25.354530 Beccari, G., Prodi, A., Senatore, M.T., Balmas, V,. Tini, F., Onofri, A., Pedini, L., Sulyok, M,. Brocca, L., Covarelli, L. (2020). “Cultivation Area Affects the Presence of Fungal Communities and Secondary Metabolites in Italian Durum Wheat Grains.” Toxins https://www.mdpi.com/2072-6651/12/2/97 Corsi, B., Percvial-Alwyn, L., Downie, R.C., Venturini, L., Iagallo, E.M., Campos Mantello, C., McCormick-Barnes, C., See, P.T., Oliver, R.P., Moffat, C.S., Cockram, J. “Genetic analysis of wheat sensitivity to the ToxB fungal effector from Pyrenophora tritici-repentis, the causal agent of tan spot” Theoretical and Applied Genetics. https://doi.org/10.1007/s00122-019-03517-8 Derbyshire, M.C., (2020) Bioinformatic Detection of Positive Selection Pressure in Plant Pathogens: The Neutral Theory of Molecular Sequence Evolution in Action. (2020) Frontiers in Microbiology. https://doi.org/10.3389/fmicb.2020.00644 Dodhia, K.N., Cox, B.A., Oliver, R.P., Lopez-Ruiz, F.J. (2020). “When time really is money: in situ quantification of the strobilurin resistance mutation G143A in the wheat pathogen Blumeria graminis f. sp. tritici.” bioRxiv, doi: https://doi.org/10.1101/2020.08.20.258921 Graham-Taylor, C., Kamphuis, L.G., Derbyshire, M.C. (2020). “A detailed in silico analysis of secondary metabolite biosynthesis clusters in the genome of the broad host range plant pathogenic fungus Sclerotinia sclerotiorum.” BMC Genomics https://doi.org/10.1186/s12864-019-6424-4

I am trying to remodel my data into the following (from the left shape to the right shape):

Below is the reproducible initial dataframe:

{Solved, below comment solved it for me!} [ Seeing links of images posted below makes this question easy to understand! ] I would like to display in a component called post two different collections attributes. I have a component called post where I display different attributes of documens inside collection posts, but in that same component I would also like to show attribute from another collection called users, those two collections are connected with collection posts having atrribute userHandle which has a value same as some certain id of some user. I will show it all in pictures. In my firebase I have a collection called posts and I call it here; first in my Fire.js i do

I've two dataframes, one with text information and another with regex and patterns, what I need to do is to map a column from the second dataframe using regex

edit: What I need to do is to apply each regex on all df['text'] rows, and if there is a match, add the Pattern into a new column

Sample data