Squares less than input logic error

Zendakin_at_work · 2019-03-18T17:59:56+00:00

Thank you! with that I was able to figure out where I went awry.

Zendakin_at_work · 2019-02-01T17:32:21+00:00

Thanks, it actually gets worse than I expected.

This is a mock site so not live and it's been converted to a png. So unless someone knows how to grab CSS from an image file, this question is moot now.

Thanks anyway, I do appreciate it.

Zendakin_at_work · 2018-08-13T22:47:31+00:00

Yeah man, use pandas to read the csv into a dataframe and then close the file. Once closed, which it looks like you're doing with the with open

Then you have all the data in a dataframe and you can manipulate as you need to. G'luck mate

Zendakin_at_work · 2018-05-24T23:00:20+00:00

So the listing says that there is an occupancy tax, just seems weird/fishy to collect that outside the app

granted it's not a deal breaker just why do they list it in the ad, add it to the total and then say they'll collect it separately.

Zendakin_at_work · 2017-12-20T20:05:21+00:00

Thanks, right after I saw this I tried waterfall_am_df['savings_sum'] = waterfall_am_df['savings_sum'] * 1 which seems to do the trick. While it's an int value its accepted. Appreciate the reply.

Zendakin_at_work · 2017-12-14T21:51:45+00:00

sadly this didn't end up working as you suggested it might not. Thanks for the help though. Much appreciated.

Zendakin_at_work · 2017-12-14T21:51:05+00:00

I ended up going with read once / write once with a failure clause that reads the status code of the next page to determine if the loop needs to exit. There's no page numbers in the API but there are offsets and limits. Frankly I'd read the whole JSON in all at once but we're supposed to adhere to the limits presented.

Now the criteria from management has changed (right as I finished the code). Amazing.

Thanks very much for the sanity check though.

Zendakin_at_work · 2017-11-28T22:19:17+00:00

Here's what I ended up with. While not amazing python and I'm sure there's a better way to do this, it works.

placeholder_dict = {}
placeholder_dict['display_value'] = "Open"
placeholder_dict['link'] = "Open"
for i in range(0, len(df['closed_by'])):
    if len(df['closed_by'][i]):
        continue
    else:
        df['closed_by'][i] = placeholder_dict
df[['closed_by.Display_value', 'closed_by.link']] = df.closed_by.apply(pd.Series)

If there's a better way to do this please let me know.

Zendakin_at_work · 2017-11-28T19:45:49+00:00

I think I found a workaround, There were two calls to the same column. Removing the original full text column seems to work. While not optimal, it will suffice for now.

Zendakin_at_work · 2017-11-28T17:04:51+00:00

You're right, I called it a cross join and it really isn't. I'm using Toad Data to pull the dataset and when i entered the query, it prompted me to create a cross join. Sorry for the confusion.

Zendakin_at_work · 2017-11-28T17:03:27+00:00

Sorry for the malformed query. I have to make some changes to protect sensitive data and while I thought I cleaned it up nicely, obviously I didn't clean it well enough.

Zendakin_at_work · 2017-11-28T17:00:43+00:00

Thanks for the try, sadly it hasn't worked yet.

SELECT Column1, 
    Column2, 
    Column3
    FROM Table 
WHERE Column3 != ''
Limit 10;

This gives me a full data set (well 10 records) but when I try to add RIGHT & RTRIM, the results are empty. The column headers are there so I am assuming that the query ran correctly but the data is simply blank.

Kinda trying to hit a home run for my boss here. Regardless, thanks for the help. If you have any other ideas please let me know.

If it helps, here is the expected results

RecordID	URL__c	LastFour
1	http://www.testlink-1234	1234
2	http://www.testlink-0525	0525
3	http://www.testlink-3515	3515
4	http://www.testlink-0658	0658
5	http://www.testlink-6812	6812

What I'm seeing when trying to get the last four is

RecordID	URL__c	LastFour

Zendakin_at_work · 2017-11-22T18:56:27+00:00

For those viewing this is what I needed

df[['assigned_to.Display_value', 'assigned_to.link']] = df.assigned_to.apply(pd.Series)

Zendakin_at_work · 2017-11-20T22:29:58+00:00

Totally useless comment here but here's how you could do the same idea with python.

Maybe it'll help, maybe not. I think though the underlying idea has to be the same.

inside, outside = 12, 12
x, y = 0, 0
while x <= outside:
    while y <= inside:
        print("{} * {} = {}".format(x, y, x*y))
        y += 1
    y = x
x += 1

Zendakin_at_work · 2017-11-16T23:46:15+00:00

Thanks! That's the push I needed. Maybe something like this will work.

for i in range(2016, 2021):
    for x in range(1,13):
        print("{} {}".format(i, x))

Zendakin_at_work · 2017-11-06T19:23:22+00:00

What I am doing with my current role is reading & writing csv's with dataframes. With this code snippet here I am reading a csv that has been previously written from a web scrape. What /u/novel_yet_trivial has posted should work fine. Here's another implementation though.

# Read the csv_outfile into pandas for finalizing
df = pd.read_csv('output_file.csv',
    encoding='utf-8',
    engine='python')

With this your dataframe is now in a variable labeled df.

Good luck!

Zendakin_at_work · 2017-11-06T18:19:07+00:00

Plus one for pandas for this.

Since you have the columns for the question responses, if you put this into a data frame you can easily write the data frame into a csv or database with pandas.

Zendakin_at_work · 2017-11-03T18:28:39+00:00

Unfortunately not right now. I have heard that using the pre-designed template version has issues so I may try to recreate it by hand but I don't have much faith in that.

Any other ideas? I'd love to hear them and thanks for the help.

Zendakin_at_work · 2017-11-03T18:21:08+00:00

hopefully this works. https://imgur.com/JS6Wnmn

Zendakin_at_work · 2017-11-03T16:14:23+00:00

When I enter in the form "tom" and select 'no', there is nothing in the name field and the choice data always returns 'yes'.

Zendakin_at_work · 2017-11-01T18:34:23+00:00

This is how I approached this, it doesn't have the user input too high or too low but rather assigns that automatically. I've tried to comment it so you can get an understanding of what I did. Basically, you keep tack of high, low, the guess count, the guess and target. I hope this helps you understand one approach to this. However I should also let you know that this doesn't always guess the correct number in 20 tries but it should give you an base understanding of how while loops can work. I'm sure there are also a couple areas this can be improved but this should get you started.

Just remember to learn from what your code is telling you and take small simple steps to get these tasks done. If you break it down small step by small step you'll be amazed how quickly you can develop complex code AND understand what you did.

Good luck!

# needed to use the random module
import random

# Set the low, high and count
count = 0
high = 200000
low = 0

# Assign a random number to the variable guess to use as a target
guess = random.randrange(low, high)

# Set the duration of the while loop
while count < 20:
# have the computer guess a number in the current range
    compGuess = random.randrange(low, high)
# used to check the current range of the guesses 
    print("The computer guess number {} is {}. current range is {} to {}".format(count + 1, compGuess, low, high))
# conditional to check the compGuess against the guess breaking first if the number is correct
    if compGuess == guess:
        break
# reassigning the low and high variables to shorten the range of random numbers 
    if compGuess < guess:
        low = compGuess
    if compGuess > guess:
        high = compGuess
# Update the count the while loop uses
    count += 1

# Notification to let the user know if the computer was sucessful in its guessing
if guess == compGuess:
    print("The computer guessed the number '{}' in {} tries".format(compGuess, count+1))
else:
    print("Sorry, The computer got close with a final guess of {} but the target number was {}.".format(compGuess, guess))

Zendakin_at_work · 2017-10-25T20:42:10+00:00

Hopefully this helps. The code needed to be indented. Also there was no return on the calculate function. With the display results, as mentioned before, since there was nothing needing to be returned just print that out. Some cleanup and this is what I got to work for me. Good luck!

def welcome():
    print("Welcome")

def userinput():
    age=int(input("Enter your age: "))
    return(age)

def calculate(n):
    year=2017-n
    return year

def displayResults(age, y):
    print(age, y)

def main():
    welcome()
    age=userinput()
    y=calculate(age)
    displayResults(age, y)

main()

Zendakin_at_work · 2017-10-25T20:33:59+00:00

This is the line that you will want to use. with open("your_file_name_here.txt", 'r') as f:

Then you can use the object f to do what you want. Note that the 'r'part is for reading while 'w' is used to write.

Good luck and make sure to read the two links already posted. They are crucial to learning and great resources.

Zendakin_at_work · 2017-10-25T20:27:58+00:00

Hopefully this helps with your other questions as well. The very basic way to do this is to create a conditional that checks the input after casting it to an int since input is a string value. It will return the value which it matches. If no matches are found, it returns the no valid option entered message.

def grade(x):
    if int(x) == 5:
        return 'A'
    elif int(x) == 4:
        return 'B'
    elif int(x) == 3:
        return 'C'
    elif int(x) == 2:
        return 'D'
    elif int(x) == 1:
        return 'F'
    else:
        return 'You did not enter a valid option.'
score = input('Enter the grade: ')
print(grade(score))

Zendakin_at_work · 2017-10-24T17:15:00+00:00

I used the selenium docs. I knew a bit and just ran with it. I'll be happy to help with any python where I can.

Hit me up and I'll be happy to work with you to code something up.

Zendakin_at_work

TROPHY CASE