If someone wanted to work on this collaboratively or just let me watch you work for a bit, HMU! I’m an experienced programmer, but fairly inexperienced with data analysis.
Step 1: open the csv file. You can do this with programs, or you can use a spreadsheet application.
Step 2: I opted to do this via spreadsheet. Literally copying (the text from the link) and pasting it in worked. (The application added missing rows and columns automatically (no extras of any though. I’ll have to add some for analysis).)
Step 3: Saving it. I don’t want to mess things up by sorting one row or column by itself and get things out of sync.
Glancing through things, floordays are incremental not cyclical. I.e. day 1, day 2, etc. If you want to
check whether resonances are affected by days of the week, you’re going to have to create days of the week
as well as come up with your own mapping between days of the week and 7 resonances. Is this number a coincidence?
First of all, I’m sorting by Pilot, via right clicking the column. This seems to scramble the floornight column, so everything seems to be working right, to figure out who has what resonances down. (Sorting a resonance column to bring the days to the top that maximize it is isn’t super simple. Sorting by maximum values, however, is.)
Glancing at Will on non-double events, makes it seem as though it isn’t likely the best resonance. Except on double events it looks...best one time, second best the other. Alpha came out higher the other time though. The time it didn’t it was narrowly third best. There’s an argument to be made for having Will use Alpha,
Nevermind, I was reading an entry from the next pilot. Will, beta resonance seems the way to go (not a lot of data). Best (out of six): 1.7. Best out of overloads: 1.6.
Maria. Does a lot more missions. Seems strong with delta, harder to confirm across all data points considering there’s so many. Best out of first 7 is 6.01. Highest probably around 7.
Janelle is tricky. Beta? Gamma? Those 2 seem higher than the others, either way. Highest seems to be 4.66, with gamma.
The rest are short, like Will.
Corazon, alpha. Highest: 2.3, and is an order of magnitude worse with everything else.
Amir, as likely alpha as beta. Overall slightly better with alpha, though the difference is like 0.0x, where x is a number. Highest 2.something.
assuming you can use multiple people at once, but each can only have one resonance
Alpha, corazon
Beta, Amir
Gamma, Janelle
Maria, delta
If you can only send one, in order:
Maria
Janelle
Corazon Amir
I could write a function to tell if, say, delta is max, and then paste it in, and count how many that’s true for versus not...or I could move on. What if floordays are the secret? Chances of survival due seem higher than usual—ish—given the circumstances.
Three hours ago, ace pilot Maria N. returned from heading off a possible attack, exorcising the offending heteropneum so swiftly and thoroughly that your superiors saw fit to posthumously assign it the official designation “Toast”. Two hours ago, while Maria was still catatonic, a heteropneum previously considered benign (amplitude: 3.2 kCept, designation: “Earwax”) teleported onto the Sphere, flooding half of the base and injuring 21% of active personnel before dispersing. Sixteen minutes ago, sensor readings indicated that Earwax is reforming. Your communications are down, and there is no time to evacuate.
Maybe today is a supercharge day, so everyone is stronger, heterpneums and pilots alike! Maybe.
Are some resonances better on some days? Maybe. A formula to check for the best resonance (for days where all resonances are available can work like this: (F2>E2)+(F2>G2)+(F2>H2)+(F2>I2)+(F2>J2) + (F2>K2)
Name the column appropriately, [resonance name] is max, and if it is it will say 6 if it is, and the heteropneum gets overloaded in that row. Repeat as necessary, then move the floor day row over to see if there’s a (simple) matchup. If it’s a function also involving the pilot, then things are going to get complicated.
Beta resonance is best if Janelle, or (unclear subset of even numbered days which just happens to coincide...). Also happens with Will, once...
And it’s also happened on odd numbered days. Doesn’t seem to be about days.
Floor day doesn’t seem to matter (for beta resonance). Though perhaps a plot of when one resonance is best will yield a different equation, more complicated than day of week?
There’s also the possibility of trying to:
- figure out conditional probability of overload (independent of heteropneum strength) - try plotting the distributions - try calculating the distributions for the pilots with only a few datapoints, and figure out who to send out on the small chance they will succeed today like they’ve never succeeded before.
--figure out relationships between resonances, and heteropneum strength, in case that helps
--relationships between days and pilots and resonances
The part I’m not clear on, is, if you were to try to send more than one pilot (say, multiple people on one resonance) how would that work (or could multiple resonances be used in conjunction. This seems unlikely, but the prompt seems to hint at ‘you need to try something wild’. Really, at the moment I think
None of these people are likely to beat this thing. Here’s a shot in the dark: you go. We have no idea what your resonance is, or how powerful it will be. This suggests ‘figure out the most likely/most powerful resonance.’ There’s also ’don’t evacuate everyone just throw who you can in the sub, and hope they can warn ??? about anomalous heteropneums. Maybe a team can be dispatched, that will be able to take it out (and then some) and build your new theory.
Or maybe the submarine has some sort of charge, based off of its last use, that you can make use of. What to look for: effects based on last use.
The other possible analysis change, would be: don’t just focus on overload days to try to figure out the distribution, for the best combination.
If someone wanted to work on this collaboratively or just let me watch you work for a bit, HMU! I’m an experienced programmer, but fairly inexperienced with data analysis.
Using Python in a Jupyter notebook. Seaborn has a fantastic little function to quickly see pairwise graphs, it’s great to begin with. Here’s what Maria looks like after sns.pairplot(df[df.name==‘Maria N.’]): https://drive.google.com/file/d/12Q_11ZTPnyak87EXO89Vbg4am3TXc4px/view?usp=sharing
Documenting my process as I go along:
Step 1: open the csv file. You can do this with programs, or you can use a spreadsheet application.
Step 2: I opted to do this via spreadsheet. Literally copying (the text from the link) and pasting it in worked. (The application added missing rows and columns automatically (no extras of any though. I’ll have to add some for analysis).)
Step 3: Saving it. I don’t want to mess things up by sorting one row or column by itself and get things out of sync.
Glancing through things, floordays are incremental not cyclical. I.e. day 1, day 2, etc. If you want to
check whether resonances are affected by days of the week, you’re going to have to create days of the week
as well as come up with your own mapping between days of the week and 7 resonances. Is this number a coincidence?
First of all, I’m sorting by Pilot, via right clicking the column. This seems to scramble the floornight column, so everything seems to be working right, to figure out who has what resonances down. (Sorting a resonance column to bring the days to the top that maximize it is isn’t super simple. Sorting by maximum values, however, is.)
Glancing at Will on non-double events, makes it seem as though it isn’t likely the best resonance. Except on double events it looks...best one time, second best the other. Alpha came out higher the other time though. The time it didn’t it was narrowly third best. There’s an argument to be made for having Will use Alpha,
Nevermind, I was reading an entry from the next pilot. Will, beta resonance seems the way to go (not a lot of data). Best (out of six): 1.7. Best out of overloads: 1.6.
Maria. Does a lot more missions. Seems strong with delta, harder to confirm across all data points considering there’s so many. Best out of first 7 is 6.01. Highest probably around 7.
Janelle is tricky. Beta? Gamma? Those 2 seem higher than the others, either way. Highest seems to be 4.66, with gamma.
The rest are short, like Will.
Corazon, alpha. Highest: 2.3, and is an order of magnitude worse with everything else.
Amir, as likely alpha as beta. Overall slightly better with alpha, though the difference is like 0.0x, where x is a number. Highest 2.something.
assuming you can use multiple people at once, but each can only have one resonance
Alpha, corazon
Beta, Amir
Gamma, Janelle
Maria, delta
If you can only send one, in order:
Maria
Janelle
Corazon
Amir
I could write a function to tell if, say, delta is max, and then paste it in, and count how many that’s true for versus not...or I could move on. What if floordays are the secret? Chances of survival due seem higher than usual—ish—given the circumstances.
Maybe today is a supercharge day, so everyone is stronger, heterpneums and pilots alike! Maybe.
Are some resonances better on some days? Maybe. A formula to check for the best resonance (for days where all resonances are available can work like this: (F2>E2)+(F2>G2)+(F2>H2)+(F2>I2)+(F2>J2) + (F2>K2)
Name the column appropriately, [resonance name] is max, and if it is it will say 6 if it is, and the heteropneum gets overloaded in that row. Repeat as necessary, then move the floor day row over to see if there’s a (simple) matchup. If it’s a function also involving the pilot, then things are going to get complicated.
Beta resonance is best if Janelle, or (unclear subset of even numbered days which just happens to coincide...). Also happens with Will, once...
And it’s also happened on odd numbered days. Doesn’t seem to be about days.
Floor day doesn’t seem to matter (for beta resonance). Though perhaps a plot of when one resonance is best will yield a different equation, more complicated than day of week?
There’s also the possibility of trying to:
- figure out conditional probability of overload (independent of heteropneum strength)
- try plotting the distributions
- try calculating the distributions for the pilots with only a few datapoints, and figure out who to send out on the small chance they will succeed today like they’ve never succeeded before.
--figure out relationships between resonances, and heteropneum strength, in case that helps
--relationships between days and pilots and resonances
The part I’m not clear on, is, if you were to try to send more than one pilot (say, multiple people on one resonance) how would that work (or could multiple resonances be used in conjunction. This seems unlikely, but the prompt seems to hint at ‘you need to try something wild’. Really, at the moment I think
None of these people are likely to beat this thing. Here’s a shot in the dark: you go. We have no idea what your resonance is, or how powerful it will be. This suggests ‘figure out the most likely/most powerful resonance.’ There’s also ’don’t evacuate everyone just throw who you can in the sub, and hope they can warn ??? about anomalous heteropneums. Maybe a team can be dispatched, that will be able to take it out (and then some) and build your new theory.
Or maybe the submarine has some sort of charge, based off of its last use, that you can make use of. What to look for: effects based on last use.
The other possible analysis change, would be: don’t just focus on overload days to try to figure out the distribution, for the best combination.
How did you want to collaborate?/What application did you have in mind for screen sharing?
Feel free to PM me.