转行刷题leetcode+记录一下我刷多久能找到一份DA工作

----------------
Date: 01.02
Item1: 【SQL】
✓ 595. Big Countries
✓ 627. Swap Salary (update…set, case…when)
✓ 620. Not Boring Movies (mod(), not like %a%)
✓ 196. Delete Duplicate Emails
✓ 197. Rising Temperature (subdate(), self join)

***今天做了两个recruiter发来的online assessments， python和SQL， SQL能对个70%吧，python可能只有10%了。

----------------
Date: 01.03

今天没有做题，因为发现自己python基础太差了，决定把基础先搞一遍再慢慢刷题。昨天OA之后，HR来了个电面，只有10分钟，但是整体很positive，说我是很适合的candidate，虽然python做得很差，好像只有30%，但是SQL全做对了。反正之后有没有onsite面试就靠缘分了，我的直觉告诉我机会很渺茫。HR一般喜欢的人跟hiring manager想找的人还是有点差距的。

学python基础：把这个tutorial过一遍再刷题。准备这个周末看完。mark一下

https://www.programiz.com/python-programming

1. Numbers
int, float and complex
isinstance() function to check if an object belongs to a particular class.
isinstance(1+2j,complex) -  True

2. List
All the items in a list do not need to be of the same type
Lists are mutable, meaning, value of elements of a list can be altered.

3. Tuple
The only difference is that tuples are immutable. Tuples once created cannot be modified.

4. Strings
Multi-line strings can be denoted using triple quotes, ''' or """.
Like list and tuple, slicing operator [ ] can be used with string. Strings are immutable.

5. Set
Set is an unordered collection of unique items. Set is defined by values separated by comma inside braces { }. Items in a set are not ordered.
They eliminate duplicates.
'set' object does not support indexing

6. Dictionary
is an unordered collection of key-value pairs.
dictionaries are defined within braces {} with each item being a pair in the form key:value. Key and value can be of any type.

*Datatype Conversion
>>> set([1,2,3])
{1, 2, 3}
>>> tuple({5,6,7})
(5, 6, 7)
>>> list('hello')
['h', 'e', 'l', 'l', 'o']
>>> dict([[1,2],[3,4]])
{1: 2, 3: 4}



补充内容 (2019-1-6 09:21):
在这里做个python小笔记

------------
Date: 01.05
Item1: 【SQL】
--

Item2: 【Python Tutorial】
-Keywords and Identifier (keywords: calss&objects)
-Variables
-Datatypes
-Type Conversion
-I/O and Import
-Operators

Item3: 【Coursera_Statistics with R_Course4: Bayesian Statistics】
✓ week1 - Intro to Bayesian Statistics(complete)

***Bayesian好难啊，好多东西要去理解，course4还有4个week的课，还有两个course才能完成整个课程（一共5个courses），都不想坚持下去了。

------------
Date: 01.06
Item1: 【SQL】
--

Item2: 【Algorithms - Python】
✓804. Unique Morse Code Words (zip(), dictionary{}, “”.join())
✓905. Sort Array By Parity (list.append())
✓832. Flipping an Image (A[::-1] reverse list; invert value [1 if j == 0 else 0 for j in A])
✓657. Robot Return to Origin (if..else.., if i in [“”,“”])

Item3: 【Coursera_Statistics with R_Course4: Bayesian Statistics】
--

好紧张啊。(握拳~~
以前都没做过这种online test。

CPCFred 发表于 2019-1-7 11:17
好紧张啊。(握拳~~
以前都没做过这种online test。

周四还要去onsite做tech assessment，到时候真不知道咋办呢。

------------
Date: 01.07
✓461 /Hamming Distance (.format(),zip())
✓942 /DI String Match  (logics***)

***周四要去onsite做tech assessment，感觉凉凉。上面这两题都没做出来。做题越来越差鸟。明天看看能不能刷10题+5题SQL

carriekyyy 发表于 2019-1-3 01:38
对的呢，现在马上就开始投简历了，今天刚好收到一个职位data engineer发来的technical assessments，是SQ ...

问下楼主一般都在哪里投简历？