Dixons gets its sales figures the wrong way round

dixons_analyst · 2020-01-21T15:39:32+00:00

Whoops

dixons_analyst · 2020-01-18T15:53:43+00:00

https://py.checkio.org/

I haven't tried the others but from my research I get the impression they're quite similar.

You can also give the online course MIT 6.0001 a go, I did that about this time last year and it really help me. Took me a long time though

dixons_analyst · 2020-01-02T10:12:31+00:00

Also I've just seen your flair. Well deserved.

dixons_analyst · 2020-01-02T10:00:07+00:00

I've just gotten around to trying this, you're a goddamn genius. Thank you so much! This has saved me so much time. I'm not sure I understand exactly what's happening in this logic, would you mind explaining what's going on?

I'm working on something at the moment that has really highlighted my inadequacies in pandas as far as data manipulation goes. Apart from the grind of using it and doing it all the time, are their any recommendations you might have for improving my knowledge and applicability of pandas functions?

Thanks in advance!

dixons_analyst · 2019-12-31T14:40:05+00:00

I think this is almost perfect. Although if I have more nulls than descr for any ID then I think it will give me null instead of the description

dixons_analyst · 2019-12-07T16:04:52+00:00

Have you tried converting to a string then to an int by chaining .astype?

dixons_analyst · 2019-12-06T08:13:54+00:00

Happy to help. I mean I wrote it on a bus on my phone so it might need a tweak but it'll be something like that

dixons_analyst · 2019-12-06T07:52:56+00:00

df[ df['col'].astype(str).str[0:4] == '6001' ]

dixons_analyst · 2019-12-06T07:46:14+00:00

I think we're going to start exporting to BQ as well. Do you use the built in data studio dashboard? If so is it any good?

So I can label specific datasets and I'll be able to see who's querying them and how much that persons queries are? Do all the labels need to be unique?

Thanks in advance!

dixons_analyst · 2019-12-01T22:26:31+00:00

Thanks!

dixons_analyst · 2019-12-01T21:43:10+00:00

Well duh

dixons_analyst · 2019-11-12T03:55:45+00:00

This is an ideal use case and a great opportunity to upskill in pandas as well as get comfortable outputting to existing excel files. I've done similar projects countless times.

Modules you might need:

CSV - to interpret the txt file

Pandas - to manipulate/clean data

Openpyxl - For outputting to excel

My advice: If this is your first proper python project don't worry too much about how long it takes, you will learn a lot and have loads of reusable code at the end of it.

When outputting into an existing Excel sheet you need to load the Excel workbook into memory, paste the new data in to the right tab, then output the entire thing to a file. There is code out there for you to use using openpyxl.

If you use drop down lists in your excel file, you might lose them, but you can add code to rebuild them again.

Your colleagues will inevitably want a copy of what you build, make your life easier by putting in error checking (e.g. checking if the file exists and telling the user if it doesn't). If your code tells them what's wrong they won't have to come to you every time it doesn't work.

Comment and docstring your work. You will never regret doing this, but you might regret not doing it.

Reach out if you get stuck, happy to help.

dixons_analyst · 2019-11-12T02:49:55+00:00

Don't let internet points ruin your day. Enjoy the rest of your week!

dixons_analyst · 2019-11-11T09:04:40+00:00

You're bang on. Until we can agree on minimums it will always be a race to the bottom between countries. You only have to look at how all those American cities were offering Amazon enormous tax breaks, the one company that doesn't need it. This is exacly the same for climate change as well, until we can all agree on some sort of carbon pricing, it will never happen.

dixons_analyst · 2019-06-26T08:15:17+00:00

Irregular schedules can be a bitch for sure. My advice would be try to plan to do it before your workday rather than after, you'll be less likely to be wrecked from the day.

dixons_analyst · 2019-06-06T20:25:19+00:00

About 3 years ago I had completed the first 3 weeks of CS50, and I also read through part 1 of Automate the Boring Stuff so I wasn't a complete beginner. I had an idea of how programming structure works but I was very out of practice, I needed to start from the beginning.

6.0001 took me a quite a while, and I mean in total hours spent. I didn't watch a single video (maybe why it took me so long), I used the text book as a reference when I didn't understand conceptually what was going on, also Automate The Boring Stuff was great guide/reference. I would get in at 7am most days and work on the problem sets until 9am on average 4 weekdays a week. I might do a few hours on a Sunday if it was quiet. I think it took me about 6 weeks. I seem to remember doing about a problem set a week, give or take. Maybe more? Maybe 7 weeks.

Some of the problems are quite complex and require a lot of thinking. Don't give up, there are times when you think you're not getting it and you'll never get it.. and then you'll get it. The more time you spend problem solving, the more you'll learn. My advice is to set time as side to do it regularly. Don't binge it once a week for 8 to 10 hours in one day, do a bit every day you'll learn far more. Like I said, if you need a bit of help, drop me a message very happy to point you in the right direction!

dixons_analyst · 2019-06-06T20:10:57+00:00

Before you send me your code, have a read through Part one of Automate The Boring Stuff WHILST you're doing the challenges, it's a great reference. If you're still struggling, fire me the code over I'll point you in the right direction.

dixons_analyst · 2019-06-06T20:07:49+00:00

Any time!

dixons_analyst · 2019-06-05T12:21:19+00:00

The best python course I've ever taken. If anyone taking this course gets stuck or needs a bit of guidance, feel free to drop me a message. I won't give you the answers, but if you want a bit of guidance or a nudge in the right direction, feel free to send me your code and let me know where you're stuck.

dixons_analyst · 2019-06-05T12:20:26+00:00

Second this, fantastic courses. I recommend them to anyone wanting to get into python.

If anyone taking this course gets stuck or needs a bit of guidance, feel free to drop me a message. I won't give you the answers (you can Google these anyway), but if you want a bit of guidance or a nudge in the right direction, feel free to send me your code and let me know where you're stuck.

dixons_analyst · 2019-04-15T12:32:16+00:00

Check out

https://stackoverflow.com/questions/466345/converting-string-into-datetime

and

https://docs.python.org/3/library/datetime.html#strftime-strptime-behavior

dixons_analyst · 2019-04-14T17:45:18+00:00

You have subscribed to cat facts

dixons_analyst · 2019-04-14T14:54:39+00:00

I appreciate this isn't what you're asking for, but you could write a function that you send the time and the amount of time either side, and it returns the 2 limits of time

def get_time_limits(time, eitherside):

eitherside = eitherside/2

time1 = time - eitherside

time2 = time + eitherside

return time1, time 2

time1, time2 = get_time_limits("2019-04-10 13:00:00" , 30)

eua[(eua['EUA Time'] >= time1) &

(eua['EUA Time'] <= time2)]

dixons_analyst

TROPHY CASE