Tag: python
-
My 1st Dashboard :)
15 buildings, 35 aspects per building, each weighted according to importance, and then condensed into 6 key categories, with colour coding depending on how the results tumble out. What helped me get the final result? Pandas to import data from spreadsheet extract only the data I need manipulate it so we end up with…
-
Natural sorting
The joys of real world data… I received a file today with building floors: 1st, 2nd, 3rd, all the way to 22nd… Regular sorting quickly got me nowhere, with results that started 10th, 11th, 12th, 13th, 14th, 15th, 16th, 17th, 18th, 19th, 1st, 22nd, etc. This led to my discovery of the most marvellous natsort…
-
Matplotlib gallery
Matplotlib gallery – the possibilities seem near endless… A great starting point when trying to figure out how to get the result you imagine!
-
Matplotlib – really basic basics!
I had quite a few false starts with matplotlib this week before I got going… I should know better by now, but I still keep on thinking I can just go crashing in and extrapolate on what I know and it might work – time-WASTING behaviour! If I may offer some tips (which I trust…
-
Cheat sheet – Pandas, data manipulation
A few things I found I used over and over again the last few weeks – the basics… How it works – Pandas, data manipulation
-
Cheat sheet – Pandas, data selection
A quick cheat sheet on basic data selection functions – as an aid to memory until memory has become second nature 🙂 How it works – Pandas, data selection
-
Matplotlib colour library
You may wish for more colours – but it’s unlikely! https://matplotlib.org/examples/color/named_colors.html
-
Yes!
OK so I know size isn’t everything, and it may even be that there are way too many lines compared to what there should be BUT tonight I am feeling in a celebratory mood none-the-less. 6 months ago I hadn’t coded anything ever, and tonight I’ve completed my 790 line “masterpiece” (don’t laugh!) which actually…
-
Pandas – get “these” based on “those”
Here is a common scenario for me: I have 2 related dataframes, and I want to select only the values from the one dataframe based on criteria from the other dataframe. For example, below we have people (including country) and brands (related to the people) and we want to select “only brands related to people who…
-
Is it normal to get lost in your own code?
Is it normal to get lost in your own code? This week I am busy with a “real life” project (yay!) – to help me classify SAP users according to system usage and ultimately license type. The totally weird thing I’m finding is that I figure out the right way to code something so it…
Sho't left to data science 