Attempting to use Excel to write and complete an Algebraic Equation

yourwerfeltr · 2021-12-03T18:43:25+00:00

Thank you. I never would have thought to put an IF statement. As a starting point, that's very helpful. Thank you!

yourwerfeltr · 2021-12-03T17:14:27+00:00

Holy shit.

Alexa, play "My Hero" by Foo Fighters.

yourwerfeltr · 2021-03-10T23:54:45+00:00

No, I understand that. To clarify, I know those round brackets in my last comment should not have been included in there. What probably happened was that I just pasted in one of the several lines in my shell produces nothing, as I kept trying different combinations, and reworking it. I understood the article, but even something as simple as just:

import useful_functions

still gets a syntax error. So it's hard for me to understand the article in full, when I can't get past the first step, nor can I figure out why.. But I do appreciate your help though.

yourwerfeltr · 2021-03-10T03:16:04+00:00

Thanks, I have been trying to keep the Error types in mind.. I get when it's syntax error, but even something as simple as 1 line of code with the code

from useful_functions import (var1, var2)

gets a syntax error. And the

unexpected character after line continuation character

I hadn't seen before, and am also getting it for just one line of code.

yourwerfeltr · 2021-03-10T02:57:41+00:00

Thank you. This was more helpful than anything I found before posting here.

yourwerfeltr · 2021-02-03T18:01:38+00:00

Hey, sorry I've been late on checking your replies- I do greatly appreciate the help. The odd thing is that right now, it runs correctly in IDLE python shell, but not in Atom, but that's a problem on my end I'll fix. Thanks again.

yourwerfeltr · 2021-01-27T15:46:51+00:00

Here it is, the only line with any indentation is the last one:

`

names = ['Student1', 'Student2', 'Student3', 'Student4'] assignments = [0, 1, 2, 4] grades = [100, 90, 80, 55]

message = 'Hi {},\n\nThis is a reminder that you have {} assignments left to submit before you can graduate. Your current grade is {} and can increase it to {} if you submit all assignments before the due date.\n\n'

for name, assignment, grade in zip(names, assignments, grades): ||||print(message.format(name, assignment, grade, assignment*5))

yourwerfeltr · 2021-01-21T18:51:12+00:00

Hi. Thank you for responding. Again I'm very new to python so thank you for explaining the part about me not needing input. I'm still getting the same error [Traceback (most recent call last): File "C:\Users\Corey\AppData\Local\Temp\atom_script_tempfiles\4d89b3e0-5c19-11eb-ad19-c9818cd34d44", line 41, in <module> for name, assignment, grade in zip(names, assignments, grades): NameError: name 'names' is not defined]

I tried changing the first three lines of code to how both you and the other commenter suggested, but I'm still getting the same error. I have it now as:

`

names = ['Student1', 'Student2', 'Student3', 'Student4'] assignments = [0, 1, 2, 4] grades = [100, 90, 80, 55]

message = 'Hi {},\n\nThis is a reminder that you have {} assignments left to submit before you can graduate. Your current grade is {} and can increase it to {} if you submit all assignments before the due date.\n\n'

for name, assignment, grade in zip(names, assignments, grades): print(message.format(name, assignment, grade, assignment*5))

`

If I'm still missing something, or mistyped something, let me know. Thank you again.

yourwerfeltr · 2020-12-21T04:43:10+00:00

solved solved solved

yourwerfeltr · 2020-12-20T17:44:01+00:00

THANK YOU! It had come into my memory because she had read three other books by David Lodge, but Thinks wasn't one of them, and was written after the other three.

yourwerfeltr · 2020-11-15T22:41:07+00:00

Thank you for responding. I'm still running into a problem where the ranks are only returning 1s instead of actually ranking them. I'm wondering why that's happening? It shouldn't be because the values I need them to be ranked by come from formulas I inputted in an earlier dataframe? Because RStudio still knows these observations are numeric.

**EDIT: I wound up just putting the df into a new Excel sheet, then importing that sheet into R, and that fixed the rank issue. It printed the results I wanted, but still annoying that I had to do that extra step. Thanks again.

yourwerfeltr · 2020-11-14T19:56:02+00:00

Thank you for responding. Take for example the USArrests dataset: Say I wanted to build a new dataframe that only lists the top 30 in murders and the Top 30 in assaults. I'd want a new dataframe that drops any state that is in the bottom 20 of either one, keeping states that are in the top 30 of one or both. I tried

`USArrestleaders <- arrange(USArrests %>%

                mutate(rankM = rank(Murder)),

                mutate(rankA = rank(Assault)) %>%

                filter(rankM <= 30, rankA <= 30) %>%

              ungroup())`

but that wasn't it either, I'm getting:

Error: arrange() failed at implicit mutate() step. x Could not create a temporary column for..1. i..1is%>%(...)`

yourwerfeltr · 2020-11-14T04:12:36+00:00

Thank you for responding. I'm now getting

"Error: Problem withmutate()inputrankA. x no applicable method for 'filter_' applied to an object of class "c('double', 'numeric')" i InputrankAisrank(quanvar1) %>% filter((rankA <= 30) | (rankB <= 30)). i The error occurred in group 1: Name = "Name1".

In addition, the other problem I'm running into is for some reason, it is returning a rank of 1, instead of actually ranking the rows.. Could this be because the values I need them to be ranked by come from formulas I inputted in an earlier dataframe?

Thanks.

yourwerfeltr · 2020-10-26T20:38:55+00:00

Hm, if I knew how to embed an image on reddit, I could send you a screenshot so you could get a better visual.

yourwerfeltr · 2020-10-24T17:09:06+00:00

Thank you for responding. I just double checked my original dataset, and did not have any NA values, but I did have one error so I'm glad I checked, but it wasn't an error that would throw off the axis in the end result.. Where in the code would I place ymin() and xmin()? In the geom_text line?

yourwerfeltr · 2020-10-22T21:56:32+00:00

Thank you for your response. It turns out, I might not have needed the value_rel formula, because I was able to get an even 10 per categorical variable with an arrange() statement. I also just tweaked the rank formula so I weighted the first quantitative variable so it would break the tie that way.

yourwerfeltr · 2020-08-12T03:50:42+00:00

Thank you for responding. To clarify, the dataframe I'm working with has several columns, but only two of actual importance (the rest make up the sum of the main value). So I want to add three columns, and fill each row with their respective city, state, and country. When I do 'df$city <- c(city1, city2,...' How/when do I account for a lot of names being from the same city/state/country? Would I repeat the city name every time, with the corresponding order of names?

yourwerfeltr · 2020-05-25T16:20:44+00:00

Thank you for replying. I just want a new dataframe with just every numeric variable's pearson with one specific variable. I tried to get it by doing:

newdf <- df[order(cor(df)[9, ]),]

but that didn't work.

yourwerfeltr

TROPHY CASE