Tag: python
-
Break it down
Coding thought for the day: if it’s not working, break it down to its smallest component parts and you will soon find out why 🙂
-
A date with a difficult customer
Being an SAP consultant, I’m working with SAP data in Pandas quite a lot. It’s common practice to set a “forever” date of 31.12.9999 in SAP and the system handles it, however Pandas has a limitation in this regard where the date cannot readily go beyond the year 2262 which caused me a few headaches…
-
A Multi-index conundrum
A Pandas series can have more than one index value. I discovered this fact during the week when I found the .groupby() method which was going to be very useful to me in getting a count of values. I started with data similar to this and my objective was to get a summary of numbers…
-
If you enjoyed VLOOKUP…
I’ve always enjoyed VLOOKUP in Excel so it was with great joy that I learned some new methods in Pandas this week. So much more flexible & powerful – what a pleasure! .map() For example, you have a list of names in one series and a list of clothing sizes in a second series: To…
-
Merge, join and concatenate
I love this Pandas help page! I feel like I can do anything with data suddenly… Learn to merge, join, concatenate data
-
NaN values in Pandas .map()
An Excel-related conundrum Yesterday was a perfect example of how you don’t really know anything until you start trying to apply your knowledge. My day job has gazillions of occasions where I vlookup thing1 against thing2 to join spreadsheet data so I’ve been trying to do this in pandas rather than Excel, just for practice……
-
Oops! I took a sho’t left!
My journey began in March 2016 as I sat on my couch at home pondering the bizarre fact that data science seemed like a good fit with the skills I love to use AND a career that might become a passion, rather than just a job… “Nonsense!” I told myself as I flipped through Udemy…
Sho't left to data science 