SourceField

    
Start-Transcript -Path result.csv
$oc = Import-Csv oldcats.csv
$nc = Import-Csv newcats.csv
#$doc=@{}
$dnc=@{}
$dncs=@{}
$found=@{}
#foreach($a in $oc){    
# $doc.Add($a.PrimaCatTypeName.ToLower())
#}

#approaching :D
#recipe_type_id,recipe_category_id,recipe_type_description
foreach($a in $nc){
  $k=$a.recipe_type_description.ToLower()
  $v="$($a.recipe_type_id),$($a.recipe_category_id), $($a.recipe_type_description)"
  if (-not $dnc.containsKey($k)){   $dnc.Add($k,$v ) }
  if (-not $dncs.containsKey($k+"s")){   $dncs.Add($k+"s",$v ) }
}

#printing oldcat results
foreach($a in $oc){
   $k=$a.PrimaCatTypeName.ToLower()
   $head="$($a.PrimaCatTypeId), `"$($a.PrimaCatTypeName)`","
  if ($dnc.containsKey($k)){           Write-Host  "$head $($dnc[$k])"  ; $found.Add($k,$k)  }
  elseif  ($dncs.containsKey($k)){     Write-Host  "$head $($dncs[$k])" ; $found.Add($k,$k)  }
  else {     Write-Host  $head    }

}


#printing new oldcat 
Write-Host ":::New cats not found:::"
foreach($a in $nc){
  $k=$a.recipe_type_description.ToLower()
  if (-not $found.containsKey($k) -and -not $found.containsKey($k+"s") ){
    $v="$($a.recipe_type_id),$($a.recipe_category_id), `"$($a.recipe_type_description)`""
    Write-Host  $v
  }
}
Stop-Transcript

Thursday

Tuesday

A friend from inside send me the real feedback the interviewers submitted after my interview. If you ever got rejected after a great interview experience, this might help you to make sense of what the F happened.

I'll not reveal the company name, but from the interview pattern, you can guess it.
I interviewed for the position of SDE2 at this FANG company (CA, USA). I did all the coding and soft skill rounds really well (or at least that's what I thought until I saw the feedback)

3 coding rounds (20 minutes behavior +40 minutes coding)
1 behavioral (Manager- 60 minutes)
1 Design(20-minute behavior+ 40 minute design)

?1. Coding: Alien Dictionary (Leet code): feedback- No hire
I have seen that problem before, but couldn't remember the details, I was going to say I've seen the question before. But first wanted to make sure it's the same question, so asked a few follow-up questions, and I was thinking out loud about how I could approach it.
The interviewer jumped in and started giving me suggestions (I never asked for hints). In the spirit of showing my collaborative skills, I accepted the hints she gave me for a problem I already know how to solve! #facepalm! At this point it was too late to tell her I knew this problem.

Later reading the feedback, I saw in the 'Cons' section she mentioned-

she had to give me hints to get to the optimum solution. (i was thinking out loud of a brute force approach)
candidate missed variables in function and she had to point that out (it was during coding, I haven't started debugging)
No time to ask to follow up questions (she thinks someone who can solve alien dictionary wouldn't know the time complexity of topological sort)
Started on algorithm immediately (I was thinking out loud my thought process, like brute force, I didn't code or anything, just explaining how a human would solve the problem then optimize it for a machine)
Unclean code. (Don't know the reason for the comment, I was given follow-up questions, and to accommodate all that I changed the whole code from a function API to an object-oriented stand-alone application, with class and member functions, maybe I should have copied the code over to another implementation).
Didn't finish in 40 minutes (I finished coding, only further optimization and time-complexity and stuff were missed. and I don't think we have a better solution than topological sort for Alien dictionary)

?2. Coding: Given travel data {(name: travel), .. } find most frequent flyer. feedback- No hire
Coded up the solution, discussed optimization, complexities, follow-up questions. felt like a good interview. there were 2 interviewers (1 trainee).
Cons:

problem-solving approach slow for SDE2, not bar raising
there were 3 follow-up questions, only finished 2. (They never told me there were 3. During the discussion of optimization, I explained a lot of stuff, spending time in new code as well. Had they told me there was 3 part to the question I'd have kept the suggestions to a minimum.)
(Trainee) didn't consider memory-efficient solutions/trade-offs. (It was I who brought up the memory concerns, like how huge the data is, like parallel processing/ batch processing, etc. But I never coded it, it felt out of scope for me, and they never asked me either)
(Trainee) WEAK FUNCTION NAME (it was logical and a verb, I don't know what the F she was talking about)
(Trainee) Missed input to the function (I created a function API but forgot a parameter in the function, I found the error myself and fixed it before debugging. Don't see the point there either)
Biased towards his own methods (Funny!! the first interviewer said I'm taking hints, this one says I don't take hints)

?3: Manager round (Behavior): Feedback - No hire
I wasn't told this round is only behavior. I was trying to finish the answers quickly as possible so that we can start the coding. but it was entirely behavioral.
Cons:
EXP1: The answer didn't exactly match the Softskill she was looking for. Was more aligned to another Softskill.
EXP1: The candidate didn't directly talk to the customer (My immediate customer is the product owner, I can only talk to them, there are layers, I cant go find random users, my product is an e-Commerce website. Cant make sense of this comment)
EXP1: Did everything iteratively- trial and error. (I explained my approach and how 'Design thinking methodology' works. I was shocked that this experienced manager called Design thinking -trial and error and put that as a Con)
EXP2: Story not good enough for SDE2
EXP3: Story about my Startup- Candidate did not deliver the product. (I incorporated an LLC company in the US, and I'm on a student visa. By visa laws, I cant work for my own company. Plus, I cant scale the product without investment which I don't have. My journey was apparently not good enough)

?4. Coding: Given sales data log, {(product, state)...} find all products sold in all the states. Bar raiser round, Feedback- No hire
Two interviewers (1 Trainee)
Cons:

Hardcoded 50 state solution, until the interviewer pointed it out. (The question was for the US, in the clarifying questions I made the suggestion to give me the number of states as input as well so that we can use my API for all the countries. But I forgot to update my API, it was a small change though, and the number of states as an input was not there in their question)
The code wasn't clear. (There were multiple follow-up questions, like parsing data, cleaning input, error checks, etc. I updated the existing code and added other function APIs in the same code. It got a little crowded but wasn't that bad, I had the pressure of 40 minutes countdown too)
Kept unneeded comments in the code. (When I add some logic, I leave a comment for readability. When there were follow-up questions I commend old code rather than deleting them. I agree that it made the whole file a little bulky)
The Code wasn't bar-raising for SDE2
(Trainee) Syntax errors like missing brackets
Didnt use abstraction/ SOLID principles

Soft skill: I gave a negative experience and they put all my experience in the CONS!! LOL!! So much for honesty and humbleness!! It was not that bad of an experience, something about I failed to convince my team for something I wanted and instead settled for middle ground. Too bad I'm not arrogant enough for them. LOL !!

?5. Design: Given existing IoT-based product line and a powerful data ingestion pipeline. Design the dashboard, data persistence, Feedback - No Hire

Cons:

Uncomfortable with requirements specific to ML edge devices. (I asked a lot of questions on the existing pipeline and product line. I wanted to understand why they have what they have, the way they have. Seems like he wasn't comfortable sharing that with me)
Spend a lot of time bikeshedding. (Yes, I asked a lot of questions about the user and IoT devices to understand what's needed for a user. They wanted me to design a dashboard without telling me what's important for the User.)
Overall architecture was rushed, lacked specifics.
Not bar-raising for SDE2

The interview experience was good, I never thought I will be looked down upon for being simple and providing simple solutions.
I used to believe interviewers are there to help you, but NO, THEY ARE NOT! Maybe there are people who would love to bet on people, but these people were not.

I find it reveals the company culture a lot. Like, If there is a cutthroat competition in the team, they wouldn't need another competitor in the team. Or, if they get blamed for a bad hire, they don't wanna bet on people. Or, they're just not trained well enough to interview engineers/ leaders/ dreamers/ wild ducks!

I felt really disappointed reading the feedback, some of these comments felt really silly. Maybe it all comes down to the first impression. If you like someone, you automatically notice their strengths and notice their flaws otherwise.

Yeah, there were some really good comments too, I'm not sharing it here, it's already a long post. The bottom line is, those comments were apparently not strong enough to change their mind. It's also confusing to see how they weigh these comments, like, one interviewer wrote, "he used a technique I have never seen before which reduced the code lines and complexity(bitwise operation)", and yet wrote in Cons 'Not bar-raising for SDE2' LOL!!!

I'm really grateful to the friend who shared this feedback, disappointing, but still, I learned a lot. I don't behave like interviewers are my friends anymore or they are better than me. Often these people are from the same team working in the same position, just don't give them a chance to look down upon you!
Maybe, if they feel you are better than them they'll realize you are in a different league and they can't compete with you and hence not a threat to them in the team. During coding, don't give them anything more than they asked for, they might have follow-up questions, let them come to you with that. Sometimes they haven't even thought of or are aware of the optimizations you suggest. Try to start with the best/ optimum solution you can think off, you can explain logic using a dumbed down version, but code better be the optimum solution, a simple solution may not get you through 'Bar raiser expectation' for SDE2 or higher. Remember, 40 minutes just flies by.

Bottom line, COMMAND RESPECT, you can't expect or demand it, and if you are really bummed about rejection, just remember, interviewers, are also just people, sometimes scared, intimidated or clueless. Or it was just bad timing that you couldn't show off every checklist items they have. Reading my feedback, I felt, an automated system could have run this interview, just looking for items or signs to check, I didn't see much humane wisdom in feedback!

So, did it work for me?
Yeah, in the last 2 months...
Interviewed for SDE2 at SAP and got the offer for Senior SDE.
Interviewed for SDE2 at Uber and got the offer for SDE2 at the location and team of my choice.
I joined Uber (CA, USA)

Monday

windows batch save screenshot

      
set d=%date:~-4,4%-%date:~-10,2%-%date:~7,2%_%time:~0,2%%time:~3,2%%time:~6,2%
c:\tools\magic\magick.exe clipboard:  c:\workshot\%d%.png

Friday

250 positive words

Positive words starting with the letter A

1. Absolutely – with no qualification, restriction, or limitation

2. Abundant – existing or available in large quantities

3. Accessible – friendly and amicable to talk with

4. Acclaimed – publicly praised; celebrated

5. Accommodative – friendly and flexible

6. Achievement – an accomplishment

7. Adaptive – changing oneself according to the environment and the surroundings

8. Admire – look up to and feel impressed

9. Adore – to love someone very much

10. Adulation – very great admiration

11. Affability – having the tendency to be friendly

12. Agathist – a person who believes that all things tend towards the ultimate good

13. Alive – living

14. Amuse – impress

15. Animated – having liveliness shine through

16. Approve – officially agree to or accept as satisfactory

17. Assure – tell someone something positively to dispel any doubts

18. Attractive – being fascinating and mesmerizing

19. Awesome – something breathtakingly amazing
Positive words starting with the letter B

20. Baronial – impressive in appearance

21. Beaming – radiating

22. Beautiful – having qualities that delight and pleases the senses

23. Beguiling – highly charming

24. Beloved – greatly loved

25. Benignant – kind

26. Best – surpassing all others in quality or excellence

27. Bewitching – enchanting

28. Boss – slang for excellent

29. Brainy – smart

30. Breathtaking – awe-inspiring

31. Bubbly – full of cheerful high spirits

Related: Unique Words
Positive words starting with the letter C

32. Centered – goal-oriented

33. Champion – holding first place in a contest

34. Charismatic – possessing an extraordinary ability to attract

35. Charming – fascinating

36. Cheerful – having life or vigor or spirit

37. Chic – fashionable

38. Chipper – lively

39. Chummy – friendly

40. Classy – elegant

41. Clever – possessing quickness of intellect

42. Colorful – interesting

43. Comical – funny

44. Communicative – able to communicate in a good and productive way

45. Constant – steadfast in purpose

46. Courageous – possessing courage
Positive words starting with the letter D

47. Definite – free from doubt

48. Delectable – greatly pleasing

49. Delicious – highly pleasing to the senses

50. Delightful – bringing pleasure

51. Dependable – worthy of trust or reliance

52. Dignified – respectable

53. Divine – heavenly

54. Down-to-earth – realistic

55. Dreamy – fantasy-like

56. Dynamite – outstanding
Positive words starting with the letter E

57. Ecstatic – pleasurable

58. Electrifying – causing a surge of excitement or emotion

59. Employable – one who is qualified and ready to work

60. Empowered – having power or confidence to make relevant choices to one’s situation

61. Endearing – making beloved

62. Enjoyable – pleasure or enjoyment

63. Enriching – something that improves or adds value

64. Enthusiastic – having or showing intense and eager enjoyment

65. Enticing – alluring

66. Especial – exceptional

67. Excellent – of the finest or highest quality

68. Exciting – stimulating interest

69. Exhilarating – making lively

70. Exultant – characterized by rejoicing
Positive words starting with the letter F

71. Fab – extremely pleasing

72. Fain – pleased or willing under the circumstances

73. Fantastic – extraordinarily good or attractive

74. Fashionable – having refined taste in manners or dress.

75. Favorite – preferred before all others of the same kind

76. Fearless – bold and lacking fear

77. Fetching – capturing the interest

78. Fiery – passionate and burning strongly and brightly

79. Friend – a person whom one knows and with whom one has a bond of mutual affection

80. Fun – enjoyable
Positive words starting with the letter G

81. Gallant – honorable and heroic

82. Gay — lighthearted and carefree

83. Genuine – authentic

84. Gifted – skillful or talented in some field

85. Gleaming – bright with a steady but dimmed shining or light

86. Glittering – impressively elaborate

87. Gnarly – outstanding

88. Goodhearted – generous

89. Grandiose – characterized by the greatness of intent

90. Greatest – highest in quality or size

91. Gumptious – having good judgment and perception
Positive words starting with the letter H

92. Happy – marked by good luck

93. Heavenly – extremely pleasurable or good

94. Honorable – worthy of respect or honor

95. Hospitable – generous or favorable towards quests

96. Humanitarian – having concern for helping and improve welfare and happiness of humans

97. Hypnotic – attracting interest as if by spell
Positive words starting with the letter I

98. Ideal – considered the best of its kind or highly satisfactory

99. Imaginative – creative

100. Impeccable – flawless

101. Impressive – anything that is or creates a remarkable or striking impression

102. Incredible – extraordinary good

103. Innovative – the creation of new things or ideas

104. Insightful – having or showing insight

105. Inspiring – encouraging

106. Instinctive – driven or acted by impulse and without thinking

107. Intellectual – clever

108. Irresistible – impossible to resist
Positive words starting with the letter J

108. Jammy – lucky

109. Jesting – light-hearted

110. Jolly – full of good humor and merry spirits

111. Jovial – characterized by good cheer and hearty conviviality

112. Joysome – inspiring or causing gladness or joy

113. Judicious – exhibiting or having sound judgment

114. Juicy – enticing

115. Just – righteous
Positive words starting with the letter K

116. Keen – intellectual quickness

117. Kind-hearted – having a friendly and cheerful disposition

118. Knightly – chivalrous

119. Knockout – strikingly impressive or attractive

120. Knowledgeable – intelligent
Positive words starting with the letter L

121. Laid-back – easy-going

122. Lambent – softly brilliant

123. Laudable – praiseworthy

124. Legendary – extremely popular

125. Level-headed – rational

126. Likable – easy to like

127. Lionhearted – courageous

128. Lively – full of life

129. Lovely – full of love

130. Luminous – emitting light or full of light
Positive words starting with the letter M

131. Magical – enchanting

132. Magnetic – having an ability or power to attract

133. Magnificent – splendid or elegant in appearance

134. Majestic – noble

135. Marvelous – extraordinarily great or good.

136. Masterful – very skillful or powerful

137. Mindful – attentive

138. Miraculous – so wonderful and astounding as to suggest a miracle

139. Motivated – enthusiastic striving toward goal or action

140. Moving – capable of arousing deep emotion
Positive words starting with the letter N

141. Neighborly – exhibiting or having the qualities of a friendly neighbor

142. Nifty – very good

143. Noble – showing or having qualities of high moral, rank or dignity

144. Numinous – awe-inspiring
Positive words starting with the letter O

145. Obedient – dutifully complying with the commands or instructions of those in authority

146. Obliging – showing readiness to do favors to others

147. Observant – paying close attention to details

148. On-target – accurate

149. Open-hearted – kind and generous

150. Open-minded – ready or receptive to new and different ideas

151. Optimistic – disposed to take the most favorable or hopeful view of the matter

152. Orderly – systematic

153. Organized – efficient or methodical in function or arrangement

154. Original – authentic

155. Outgoing – responsive and sociable to others

156. Out-of-this-world – extremely impressive or enjoyable

157. Outstanding – prominent or noticeable of others of its kind

158. Overjoyed – extremely happy and joyful
Parade Daily
Celebrity interviews, recipes and health tips delivered to your inbox.
Email Address
Please enter a valid email address.
Thanks for signing up! Please check your email to confirm your subscription.
Positive words starting with the letter P

159. Pally – friendly

160. Paramount – supreme

161. Passionate – having or showing powerful emotions

162. Patient – calm during difficult situations

163. Peaceful – not disturbed by turmoil

164. Peachy – splendid

165. Peppy – cheerful and vigorous

166. Perceptive – having or showing ability and keenness of perception

167. Persevering – constant in the execution of a purpose

168. Persistent – refusing to give up

169. Personable – pleasing in appearance or personality

170. Persuasive – convincing

171. Phenomenal – outstanding

172. Philanthropic – generous in assistance

173. Picturesque – quaintly attractive and charming; pretty as a picture

174. Piquant – charming or interesting175.

175. Playful – full of high spirits and fun

176. Polished – elegant

177. Posh – fashionable and smart

178. Prized – cherished

179. Proactive – acting in advance to deal with an expected difficulty or change

180. Promising – showing or having the possibility of achievement or excellence

181. Proud – feeling of self-respect or self-worth;

182. Punctual – prompt
Positive words starting with the letter Q

183. Queenly – a regal and distinguished woman

184. Quick-witted – mentally sharp, nimble and alert

185. Quirky – merry and unconventional
Positive words starting with the letter R

186. Rad – excellent

187. Radiant – emanating great love, joy or happiness

188. Rapturous – filled with great joy or delight

189. Razor-sharp – extremely sharp; quick-witted or very clever

190. Reassuring – relieving anxiety and restoring confidence

191. Recherche – exquisite

192. Recommendable – worthy of praise or to be recommended

193. Refulgent – radiant

194. Reliable – trustworthy

195. Remarkable – worthy of notice or consideration

196. Resilient – characterized by the ability to recover readily from misfortune

197. Resourceful – having the ability to find clever and quick ways to overcome difficulties

198. Respectable – worthy of respect or high esteem

199. Revolutionary – extraordinarily good and surprising
Positive words starting with the letter S

200. Saccharine – extremely sweet

201. Sagacious – acutely wise and insightful

202. Savvy – well-informed, perceptive or shrewd

203. Self-assured – showing or having confidence and poise

204. Sensational – exceptionally good

205. Sincere – genuine

206. Snappy – energetic

207. Snazzy – fashionable

208. Spellbinding – fascinating

209. Splendiferous – very beautiful

210. Spunky – spirited

211. Stellar – exceptional

212. Striking – sensational or exciting in appearance or in effect
Positive words starting with the letter T

213. Teeming – productive

214. Tender-hearted – having a great sensibility and kindness

215. Thoughtful – demonstrating careful consideration or thought

216. Thriving – very profitable and lively

217. Timeless – classic and always in style

218. Tolerant – tending to accept, allow, permit or understand something or the existence of something

219. Trailblazing – innovative

220. Transcendental – superior; extraordinary

221. Tubular – awesome; cool
Positive words starting with the letter U

222. Upbeat – having a fast and positive tone

223. Uplifting – inspiring hope or happiness

224. Upstanding – respectable

225. Urbane – polite
Positive words starting with the letter V

226. Valiant – brave and courageous

227. Vibrant – lively and bright

228. Victorious – being the winner in something

229. Visionary – one who has visions or positive ideas about future

230. Vivacious – animated and lively
Positive words starting with the letter W

231. Warm – kind and caring

232. Well-read – highly educated

233. Whimsical – playful and amusing

234. Whiz-bang – successful

235. Wholehearted – unconditional commitment

236. Winsome – charming

237. Wise – having knowledge

238. Witty – clever and funny

239. Wizardly – remarkable in performance, execution or design

240. Wondrous – extraordinary

241. Worldly – very sophisticated
Positive words starting with the letter X

242. Xenial – hospitable to others

243. Xenodochial – friendly to strangers or guests
Positive words starting with the letter Y

244. Yay – an expression of approval and excitement

245. Yes – an affirmative answer or decision

246. Yummiest – the most delicious
Positive words starting with the letter Z

247. Zappy – energetic and lively

248. Zazzy – flashy

249. Zealful – passionate enthusiasm

250. Zealous – having or exhibiting strong enthusiasm or passion

Tuesday

log file from folder for unit test

      
        [TestMethod]
        public void TransactionBalance_FilesTest()
        {

            const string exp = "System.Data.InvalidExpressionException: ";
            var test_files = Directory.GetFiles(@"c:\temp\usage", "*.txt");
            HashSet<string> h = new HashSet<string>();

            var regex1 = new Regex(@"([C|D]{1})([0-9]{2})([0-9]{2})([0-9]{2})([A-Z]{3})(-?\d.*)");
            int done1 = 0;
            int done2 = 0;
            foreach (var file in test_files)
            {
                foreach (var l in File.ReadAllLines(file))
                {
                    int pos = l.IndexOf(exp);
                    if (pos > -1)
                    {
                        var data = l.Substring(pos + exp.Length);


                        var match = regex1.Match(data);
                        if (match.Groups.Count < 7)
                        {
                            data = PreprocessData(data);
                            match = regex1.Match(data);
                            if (match.Groups.Count < 7)
                            {
                                if (!h.Contains(data))
                                {
                                    h.Add(data + "      =>ORIG=>  " + l);
                                }
                            }
                            else {
                                done2 += 1;
                            }
                        }
                        else {
                            done1 += 1;
                        }

                    }
                }
            }

            StringBuilder sb = new StringBuilder("completed "+done1+" second attempt="+done2+"\r\n");
            foreach (string item in h)
            {
                sb.AppendLine(item);
            }

            TestMaker tm = new TestMaker(man);
            Console.WriteLine(tm.Save("txt", sb.ToString()));
        }

Sunday

WishList2

 Vital Proteins Chocolate Collagen Powder Supplement (Type I, III) for Skin Hair Nail Joint 
 Baguette or Sandwich Silicone Cooking Form  

vitamin d3

Tuesday

companies Google Style Guides

Google at github:

Google at github: google| GoogleCloudPlatform| openjdk| googlers|

google leetcode questions

from https://github.com/Blankj/awesome-java-leetcode/blob/master/Companies.md Google 4,10,17,20,22,23,31,42,44,50,54,56,57,66,128,133,139,140,146,155,158 159,162,163,166,173,200,208,212,214,218,224,228,230,231,239,240,246 247,249,251,253,257,259,261,266,269,270,271,272,274,276,279,280,281 282,284,286,288,289,293,294,295,297,298,302,305,308,309,310,312,313 314,315,316,317,318,320,321,323,324,326,327,329,330,331,332,336,340 341,345,346,348,351,353,354,356,357,358,359,360,361,362,363,368,369 370,373,374,375,377,378,379,380,382,388,389,391,393,394,397,399,400 401,402,406,407,408,409,411,415,417,418,421,422,425,444,447,448,451 459,460,463,465,469,471,474,475,480,481-487,490,493,494,498,501,503 505,506,514,520,521,522,524,526,527,530,531,533,534,535,541,542,543 544,545,551,552,560,562,568,569,572 75-questions: top 75 blind original post| 75 video | 75 spreadsheet| 75-leetcode| Topics: Binary Search, Two pointers, Binary Tree,BackTracking, DFS,BFS,Graph,Dynamic Programming coding interview questions for different companies |
4uvak ne githubi robit leetcode|

big o notation poster

big o notation poster:

differnt pdf on github: https://github.com/ro31337/bigoposter/raw/master/bigoposter.pdf

Monday

ffmpeg convert all audio webm files into folder into mp4

         


for /r %%v in (*.webm) do ffmpeg -i "%%v" -c copy   "%%~nv.mp4"

Wednesday

c# removing non printable characters in xml json

s = Regex.Replace(s, @"\p{C}+", string.Empty);

Tuesday

leetcode study methods

Barbara Oakley repetition method seems like a lot of work , but could be most reliable:
A.Many users of spaced repetition strive for three additional exposures to new information within the first 24 hours of learning it.
B.Following that, they aim to revisit the content daily for the next week.
C.After the first week, they make a point of revisiting the content from time to time so it doesn’t fade from memory.

Laura method 
A.Setting up education schedule - helps with motivation and consistency
B.have consitent pattern when and where you want to start working and which topic on particular day  
C.leetcoding 30 min to 1h a day max 
D.Topics: arrays,trees, graphs, strings, dfs/bfs,bit manipulations,stacks, queue


Process:
 pick two problems from the topics:
 20 minutes for the first problem 
 20 minutes for the second problem

Day 1: 
Work on problem from topic (solving steps aka SS ):
1.define assumptions, inputs/outputs,edge cases, potential working solution in plain english and hadwritten code 
2.translate to leetcode editor
3.compare solution to official 
4.If you cannot solve it for 5-10 minutes look for solution 

Day 2: 
Switch to second topic and do SS for problem from second topic.

Day 3: 
Quick reflection on problem from Day 1: where did u go wrong, and do handwritten solution again and retype solution and repeat all SS steps. 
Plus solve one extra problem of same topic from Day1. 

Day 4:
Quick reflection on problem from Day 2: where did u go wrong, and do handwritten solution again and retype solution and repeat all SS steps. 
Plus solve one extra problem of same topic from Day2. 

Day 5:
Quick reflection on problem from Day 3: where did u go wrong, and do handwritten solution again and retype solution and repeat all SS steps. 
Plus solve one extra problem of same topic from Day3. 

Day 6:
Quick reflection on problem from Day 4: where did u go wrong, and do handwritten solution again and retype solution and repeat all SS steps. 
Plus solve one extra problem of same topic from Day4. 

Day 7: rest and leetcode free day :).

Tips: 
G1.Goal is to solve problem (even with bruteforce solution)
Make most obvious bruteforce solution first  - translate to leetcode editor, fix bugs 
in next session think how to optimise solution and what are trade-offs -  
G2.practice solving problems out loud - on the interview u kinda freeze up and u need to talk out loud to let interviewwer ur thoughts  
G3.record urself answering leetcode Qs out loud or do mock interview  
G4.create club w/ur friends

Thursday

"This file requires a newer version of Anki" apkg error resolved

Unfortunately, anki software just jammed all those fields into one field the database with some kind of separator.Which is a very messy way to store data. And apparently different version of Anki storing data into different database inside apkg file. Here is new version of apkg converters that reads data from correct database.

Friday

convert excel file into sql and import all data

Here are steps how to convert convert excel file into sql and import all data
In step 1:Click on Open input file and open excel file
Click on Next Step button

In step 2:Specify sql database type (sql server, mysql, sqlite)

Click on Next Step button

In step 3:Click on Save Result file to save SQL script

sql script will have create table and insert instructions

Run sql script into database tool to export data from excel into database.

excel-to-sql

- June 04, 2021 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Wednesday

powershell lambda syntax and returing multiple values from function

#function returns multiple params including lambda function test1{ param( $a,$b,$c ) return ($c, $b,$a , {param($x) Write-Host "a1$x" }) } #receiving multiple results (including lambda ) from function call ($d,$e,$f, $a2) = test1 1 2 3 #printing result Write-Host "$d $e $f" #invoking lambda $a2.invoke("inv")

- April 14, 2021 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Thursday

windows 10 text font is too large

here is how to fix it

Here's how I fixed it on mine, thanks to G. Ortega...

"if the characters are big but windows configuration windows says that scalling it's at 100%.

the solution that worked for me was:

1.- set it to 125%.

2.- log out (windows requires it) -> log in.

3.- set it back to 100%.

4.- repeat step 2.

5.- now everything it's back to normal.

- March 25, 2021 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Wednesday

dbo.BeSplit TSQL function to split by beginning and end string

ALTER FUNCTION dbo.BeSplit ( @re varchar(max), @beg varchar(max), @end varchar(max)) RETURNS varchar(max) WITH EXECUTE AS CALLER AS BEGIN declare @in int = Charindex(@beg,@re) declare @ou int =-1 declare @locid varchar(max) declare @l11 int =LEN(@beg) if @in > 0 set @ou = Charindex(@end,@re,@in) else return null if @ou > 0 set @locid= SUBSTRING ( @re ,@in+@l11 , @ou-(@in+@l11) ) else set @locid= SUBSTRING ( @re ,@in+@l11 , LEN(@re)-(@in+@l11)+1) RETURN @locid END; GO
call example: select Page,dbo.BeSplit(Page,'locationid=','&') as locationid,dbo.BeSplit(Page,'comp=','&') as familyname from ga

- December 02, 2020 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Friday

putty python .vmrc

putty oceandeep settings: ----------------------------- default foreground (rgb) : 7,199,238 default background (rgb) : 16,48,64 .vimrc setting ----------------------------- set listchars=tab:>-,trail:- set list set tabstop=4 colo desert set nocompatible " be iMproved, required filetype off " required call plug#begin() Plug 'tpope/vim-sensible' Plug 'tpope/vim-fugitive' " On-demand loading Plug 'scrooloose/nerdtree', { 'on': 'NERDTreeToggle' } Plug 'vim-airline/vim-airline' Plug 'vim-airline/vim-airline-themes' Plug 'majutsushi/tagbar' Plug 'junegunn/fzf' Plug 'scrooloose/syntastic' Plug 'tpope/vim-surround' call plug#end() nmap <leader>ne :NERDTree<cr> nmap <F8> :TagbarToggle<CR>

- September 06, 2019 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Monday

automatically create a folder with today's date

apps for creating folders
set d=%date:~-4,4%-%date:~-10,2%-%date:~7,2% d: cd work mkdir %d% cd %d% explorer d:\work\%d%

- August 12, 2019 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Tuesday

run python script as ubuntu service

step 1 - create service file here is archivebot.service I created for my server
[Unit] Description=archivebot [Service] ExecStart=/bin/bash -c "cd /home/al/slack-archive-bot;export SLACK_API_TOKEN=TOKEN_HERE && python archivebot.py" [Install] WantedBy=multi-user.target
Then I did everything according to this example :
Step 1: I created this file (note location) which essentially fires a bash process with an extended argument. You could fire your own command which could be different from bash.

[root@y500-fedora ~]# cat /etc/systemd/system/foo.service [Unit] Description=foo [Service] ExecStart=/bin/bash -c "while true; do /bin/inotifywait -qq --event close_write /sys/class/backlight/acpi_video0/brightness; su myusername -c '/bin/xbacklight -display :0 -set $(cat /sys/class/backlight/acpi_video0/brightness)'; done" [Install] WantedBy=multi-user.target

Step 2:

Reload systemd:

systemctl daemon-reload

Start the new service:

systemctl enable foo

(similarly you can disable it)

(optional) Step 3: It should start automatically at next reboot into multi-user mode (run level 3) but if you want to start it right away:

systemctl start foo systemctl status foo # optional, just to verify

Update: For completeness, I should add that ubuntu bionic seems to have a very thorough man page. RTFM here

- July 23, 2019 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Monday

Study path for artificial intelligence and Machine learning:

Andrew Ng's lecture series on AI

Andrew Ng's lecture at the Stanford Business School

Andrew Ng - The State of Artificial Intelligence

Andrew Ng is a visiting professor at Stanford, founder of Coursera and currently the head of research at Alibaba. The above videos should give you all the basics you need about AI.
Below schema from this article I like this map below - because there are a lot of areas and directions in learning AI it shows it as subway map: AI study map

- February 11, 2019 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

powershell sitecore remove item from pipe separated list

here is function how to do it :
[string]$test ="{uka}|{taka}|{4aka}|{boom}" function RemovePipeElement { param ( [string]$body, [string]$elem ) [string]$res=$body; [int]$a=$body.IndexOf($elem) if ($a -gt -1) { [string]$newbod=""; [bool] $first=$TRUE; $arr=$body.split("|"); foreach ($e in $arr) { if ($e -ne $elem ) { if ($first){ [string]$newbod=$e; $first=$FALSE; }else{ [string]$newbod=$newbod+"|"+$e; } } } $res=$newbod; } return $res; } Write-Host "$test" [string]$uid=RemovePipeElement $test "{uka}"; Write-Host "$uid" [string]$uid=RemovePipeElement $test "{4aka}"; Write-Host "$uid" [string]$uid=RemovePipeElement $test "{boom}"; Write-Host "$uid" [string]$uid=RemovePipeElement $test "{taka}"; Write-Host "$uid"

- February 11, 2019 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: pipe, powershell

Tuesday

change exe or dll file description

exe or dll file properies can be changed by verpach:

set VERSION="1.2.3.4 (%date%)" set FILEDESCR=/s desc "sample foodll description" set BUILDINFO=/s pb "Built by %USERNAME%" set COMPINFO=/s company "sample company" /s (c) "(c) Sample copyleft 2009" set PRODINFO=/s product "sample product" /pv "1.0.22.33" verpatch /va foodll.dll %VERSION% %FILEDESCR% %COMPINFO% %PRODINFO% %BUILDINFO%

- October 09, 2018 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Monday

powershell search string

this is powershell script to search into log files but it could search into any text base files like csv,xml or json: id displays list of files when search string found:
cd c:\inetpub\Data\logs Get-ChildItem -Recurse *.* | Select-String -Pattern "my search string" | Select-Object -Unique Path

- September 10, 2018 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Wednesday

startup podcast shows list

The Art of Product

Build Your SaaS

Bootstrapped Web

Founder’s Journey

Hooked on Product

RogueStartups

The Tropical MBA

Indie Hackers

ZenFounder

This Week in Startups

Startup

Akimbo

Stacking Benjamins

Money For The Rest Of Us

Planet Money

Reply All

Daily Tech Headlines

Current Geek

99% Invisible

System Mastery

- June 27, 2018 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Friday

git links from saraford talk

Git For Humans

GitHub Cheatsheet

Git Visualization tool

Git Visualization tool repo

Git Visualization tool walkthrough

Git on-demand training by GitHub

ohshitgit.com

Sara Ford's what I learned about Git and GitHub from working at GitHub talk notes

128 Git and GitHub tips for Windows users

- May 18, 2018 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Tuesday

sitecore upload image programmatically to media library

here is how controller class looks like:
using MyCorp.MyLib.Entities.WebService; using Sitecore.Configuration; using Sitecore.Resources.Media; using Sitecore.SecurityModel; using Sitecore.Services.Infrastructure.Web.Http; using System; using System.IO; using System.Linq; using System.Net; using System.Net.Http; using System.Threading.Tasks; using System.Web; using System.Web.Http; namespace MyCorp.MyLib.Feature.EmailService { [OverrideExceptionFilters] public class ImageServiceController : ServicesApiController { /// <summary> /// Save stream as file into sitecore /// </summary> /// <param name="stream"></param> /// <param name="req"></param> private void SaveFileIntoSitecore(Stream stream, ImageRequest req ) { var mediaCreator = new MediaCreator(); var options = new MediaCreatorOptions { AlternateText = req.AltText, OverwriteExisting = true, FileBased = false, Versioned = false, IncludeExtensionInItemName = false, Database = Factory.GetDatabase("master"),//web? Destination = req.DestinationName ///logo.jpg }; using (var memoryStream = new MemoryStream()) { stream.CopyTo(memoryStream); using (new SecurityDisabler()) mediaCreator.CreateFromStream(memoryStream, req.DestinationName, options); } } [HttpPost, OverrideExceptionFilters] public async Task<HttpResponseMessage> Upload() { if (!Request.Content.IsMimeMultipartContent()) { throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType); } string root = HttpContext.Current.Server.MapPath("~/App_Data"); var provider = new MultipartFormDataStreamProvider(root); try { // Read the form data and return an async data. var result = await Request.Content.ReadAsMultipartAsync(provider); ImageRequest req = new ImageRequest(); // This illustrates how to get the form data. foreach (var key in provider.FormData.AllKeys) { foreach (var val in provider.FormData.GetValues(key)) { // return multiple value from FormData if (key == "DestinationName") { req.DestinationName = val; } else if (key == "DestinationFolder") { req.DestinationFolder = val; } } } if (result.FileData.Any()) { // This illustrates how to get the file names for uploaded files. foreach (var file in result.FileData) { FileInfo fileInfo = new FileInfo(file.LocalFileName); if (fileInfo.Exists) { //Save every file to sitecore var s = fileInfo.OpenRead(); SaveFileIntoSitecore(s, req); } } } HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, req); return response; } catch (System.Exception e) { return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e); } } } }

- May 01, 2018 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Monday

javascript next month date formatting coupon source code

function NextMonth1() { var now = new Date(); if (now.getMonth() == 11) { return new Date(now.getFullYear() + 1, 0, 1); } else { return new Date(now.getFullYear(), now.getMonth() + 1, 1); } } function formatDate(date) { var monthNames = [ "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" ]; var day = date.getDate(); var monthIndex = date.getMonth(); var year = date.getFullYear(); return day + ' ' + monthNames[monthIndex] + ' ' + year; } var div = document.getElementById('couponText'); div.innerHTML += "Effective till " + formatDate(NextMonth1());

- January 29, 2018 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Wednesday

c# return zip stream from api

public Stream GetDataFile(string locationId) { int cid; DateTime tran = DateTime.Now.Date; Check(string.IsNullOrWhiteSpace(locationId), "locationId field is missing."); Check(!int.TryParse(locationId, out cid), "locationId must be numeric."); DataFileRepository repository = new DataFileRepository(); /*returning stream*/ var resp = WebOperationContext.Current.OutgoingResponse; resp.ContentType = "application/octet-stream"; resp.Headers.Add("Content-Disposition", "attachment; filename=\"myfile.zip\""); return ZipStream(repository.GetCSVStream(cid)); } /// <summary> /// Check condition and generate exception if condition met. /// </summary> /// <param name="condition"></param> /// <param name="exp"></param> public void Check(bool condition, string exp) { if (condition) { AssertionException up = new AssertionException(exp); throw up; } } /// <summary> /// Method for zipping streams /// </summary> /// <param name="stream"></param> /// <returns></returns> public Stream ZipStream(Stream stream) { stream.Position = 0; var ar = new ZipArchive(); ar.AddItem("myfile.csv", stream, true, FileAttributes.Normal); var zip = new TempFileStream(); ar.Save(zip, false); zip.Position = 0; return zip; }
interface declaration in API webservice is very simple:
[OperationContract] [WebGet(UriTemplate = "menu/datafile/{locationId}")] Stream GetDataFile(string locationId);

- November 15, 2017 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

IDataReader into csv

/// <summary> /// Method for converting reader into CSV /// </summary> /// <param name="dataReader"></param> /// <param name="includeHeaderAsFirstRow"></param> /// <param name="separator"></param> /// <returns></returns> public Stream ToCSV(IDataReader dataReader, bool includeHeaderAsFirstRow, string separator) { Stream csv = new TempFileStream(); StreamWriter csvRows = new StreamWriter(csv); StringBuilder sb = null; if (includeHeaderAsFirstRow) { sb = new StringBuilder(); for (int index = 0; index < dataReader.FieldCount; index++) { if (dataReader.GetName(index) != null) sb.Append(dataReader.GetName(index)); if (index < dataReader.FieldCount - 1) sb.Append(separator); } csvRows.WriteLine(sb.ToString()); } while (dataReader.Read()) { sb = new StringBuilder(); for (int index = 0; index < dataReader.FieldCount - 1; index++) { if (!dataReader.IsDBNull(index)) { string value = dataReader.GetValue(index).ToString(); if (dataReader.GetFieldType(index) == typeof(String)) { //If double quotes are used in value, ensure each are replaced but 2. if (value.IndexOf("\"") >= 0) value = value.Replace("\"", "\"\""); //If separtor are is in value, ensure it is put in double quotes. if (value.IndexOf(separator) >= 0) value = "\"" + value + "\""; } sb.Append(value); } if (index < dataReader.FieldCount - 1) sb.Append(separator); } if (!dataReader.IsDBNull(dataReader.FieldCount - 1)) sb.Append(dataReader.GetValue(dataReader.FieldCount - 1).ToString().Replace(separator, " ")); csvRows.WriteLine(sb.ToString()); } csvRows.Flush(); dataReader.Close(); return csv; }

- November 15, 2017 No comments:
Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: csv

Search This Blog

Home

▼ 2026 (1)

▼ Apr (1)

make ubuntu business casual

► 2025 (1)

► Apr (1)

► 2024 (8)

► Nov (3)

► Sep (2)

► Jun (1)

► Jan (2)

► 2023 (10)

► Dec (3)

► Nov (1)

► Oct (1)

► Mar (1)

► Jan (4)

► 2022 (22)

► Oct (1)

► Aug (2)

► Jul (1)

► Jun (4)

► Apr (1)

► Mar (3)

► Feb (2)

► Jan (8)

► 2021 (6)

► Dec (1)

► Nov (1)

► Jun (2)

► Apr (1)

► Mar (1)

► 2020 (1)

► Dec (1)

► 2019 (5)

► Sep (1)

► Aug (1)

► Jul (1)

► Feb (2)

► 2018 (6)

► Oct (1)

► Sep (1)

► Jun (1)

► May (2)

► Jan (1)

► 2017 (11)

► Nov (2)

► Jul (1)

► Apr (2)

► Feb (3)

► Jan (3)

► 2016 (15)

► Dec (3)

► Nov (4)

► Oct (4)

► Jul (1)

► Apr (3)

► 2015 (3)

► Sep (1)

► Jan (2)

► 2014 (2)

► May (1)

► Apr (1)

► 2013 (43)

► Dec (2)

► Nov (1)

► Sep (2)

► Aug (1)

► Jul (7)

► Jun (4)

► May (8)

► Apr (3)

► Mar (3)

► Feb (5)

► Jan (7)

► 2012 (41)

► Dec (4)

► Nov (5)

► Oct (4)

► Sep (2)

► Aug (5)

► Jul (4)

► May (3)

► Apr (8)

► Mar (3)

► Feb (3)

► 2011 (77)

► Dec (10)

► Nov (5)

► Oct (5)

► Sep (2)

► Aug (4)

► Jul (3)

► Jun (9)

► May (9)

► Apr (9)

► Mar (8)

► Feb (5)

► Jan (8)

► 2010 (103)

► Dec (14)

► Nov (5)

► Oct (10)

► Sep (4)

► Aug (4)

► Jul (20)

► Jun (14)

► May (4)

► Apr (8)

► Mar (10)

► Feb (2)

► Jan (8)

► 2009 (75)

► Dec (8)

► Nov (5)

► Oct (9)

► Sep (3)

► Aug (10)

► Jul (2)

► Jun (3)

► May (5)

► Apr (5)

► Mar (8)

► Feb (8)

► Jan (9)

► 2008 (103)

► Dec (21)

► Nov (13)

► Oct (17)

► Sep (9)

► Aug (4)

► Jul (9)

► Jun (5)

► May (2)

► Apr (3)

► Mar (2)

► Feb (10)

► Jan (8)

► 2007 (9)

► Dec (9)

codestyle

Labels

actionscript

active directory

air

ajax

Analysis Services

android

anki

AOS

asp

asp net web config

asp.net

AutoHotkey

bablo

bat

biztalk

blogging

bowser

c#

chm

circular reference error

command line

configuration

control version

cp

csharp

csv

datacontext

dot.net

excel

fix

flex

fun

FxCop

GC

google

H1B

icons

ie

ienumerable

iis

installation

javascript

join

jquery

json

ldap

links

linq

magic.exe

pdf

php

pipe

powershell

python

rdp

regexp

resources

ruby

serialization

serviceModel

sql

sql server stored procedure

ssh

ssl

tam foundation server; control version

tdd

text processing

tfs

threading

tmux

transformation

tsql

vb.net

vb6

vim

wcf

webservice

Xml

XmlDictionaryReaderQuotas

xsd

xsl