đâ⏠Life
Hi friend! Howâs the week going for you? For me, this week was frantic. A lot of client deadlines that I somehow managed to meet. Itâs miraculous how much you can get done right before a deadline. Ah, Parkinsonâs Law đ
(ŕš*á*) Anime
Although this week was intense, I canât not watch anime so I finished watching Hanasaku Iroha but it was meh. To distract from the disappointment, I rewatched a bit of Hachimitsu to Clover. For some reason, Iâve been on a slice-of-life streak lately.
Honey and Clover is about college kids at an art school going through college stuff ie. existential crises. I wasnât super into it at the beginning but the character developments were amazing and the anime reminded me of what I felt like when I was in college. Except for the last partâŚ.not gonna spoil it for anyone but if you watch it youâll know what I mean lol. Btw if you have any anime recommendations please reply to the email! â¤ď¸
đ Books
I finished reading 2 books: How to Not Die Alone and Never Split the Difference.
As its name suggests, How to Not Die Alone teaches you how to not die alone ie. how to properly date people, find love, and hopefully marry someone if youâre into that (and not get divorced). What I liked about this book is that it takes an evidence-based approach to explain what works well and what doesnât work well.
Thereâs this quiz you can take to see your dating tendencies. It seems I am very much a romanticizer. I like to think of myself as quite logical but evidently Iâm the opposite when it comes to love. đĽ
Never Split the Difference is very interesting and surprisingly practical. Itâs a book about negotiation strategies and tactics by Chris Voss, a former international hostage negotiator for the FBI.
I actually managed to put what I learned into practice immediately and helped my friend negotiate a 10% increase to his base salary + additional perks and stocks by using a combination of these tactics.
He was very nervous so we actually only used the more basic tactics:
âď¸ âFairâ: The use of the word âfairâ elicits a psychological reciprocity because people want to be fair.
đ Ranges: Using price ranges makes the person want to go with the lower boundary.
đ Saying no: You gently say no by apologizing and acknowledging that they are being generous but you simply cannot.
Next time when I have a chance to negotiate Iâd also love to try tactics such as:
â Extreme anchors: Saying a ridiculous price point if youâre forced to name a price first.
đ˘ Using very specific numbers: Apparently itâs a psychological thing that makes people think youâre at your baseline.
đť Learning & Productivity
Iâm getting more and more into the lockbox with a timer that I mentioned in last weekâs newsletter. Itâs a box to put stuff in and you canât access it for however long it is that you initially set.
Initially, I just put junk food and sweets in it but I realize I also have an issue with just opening the fridge and eating random things when Iâm bored. Like I said, I literally have no self controlâŚ
Unfortunately, you canât put the box in the fridge so this is going to sound even more ridiculous but I got these fridge locksâŚ
What I do is lock the fridge and put the keys in the lockbox too. ENVIRONMENT DESIGN. Itâs been a week and has worked very well so far. Fingers crossed I finally manage to develop the habit of intermittent fasting.
đ¨âđť Coding
I did not manage to get much blockchain coding done. Honestly, the only coding I did this week was very light for the video coming out on Saturday: 5 coding projects for beginners. Hope yâall like the video. â¤ď¸
For those of you who ask: I am x years old, can I still learn to code?
I was 48 when I got my first software job, now 49 and not far from 50, so I feel like I've achieved something special by doing this. - Vernon
đť Todayâs coding challenge (SQL/Python)
Find the 3-month rolling average of total revenue from purchases given a table with users, their purchase amount, and date purchased. Do not include returns which are represented by negative purchase values.
Output the year-month (YYYY-MM) and 3-month rolling average of revenue, sorted from earliest month to latest month. A 3-month rolling average is defined by calculating the average total revenue from all user purchases for the current month and previous two months. The first two months will not be a true 3-month rolling average since we are not given data from last year. Assume each month has at least one purchase.
Head on over here to answer the question!
*Btw if youâre prepping for data science interviews or just want to keep yourself sharp, Stratascratch is a great platform with 10k+ real interview questions on SQL and python coding, probability, product sense etc. You can use my code âtinahuangâ at checkout for 20% off. â¤ď¸
PS: Reply to this email about what youâd like to see in future editions of Boopâs Keyboard! Iâm super new to writing a newsletter and I know thereâs a lot for me to learn. ALL constructive feedback is greatly appreciated :)
-Tina
I like the newsletter especially the books because it helps me find new and interesting ones to read
Ä°t's a popular anime but when you said slice of life and school I remembered that I loved "Yahari ore no seicshun love comedy wa machigatteiru". If anyone haven't watched it. I highly recommend. And my favourite anime "Ghost in the shell" is also recommended of course.