rose tinted glasses

Append The append() method adds a single element to the end of a list. If the element being added is a sequence (list, tuple, etc.), it will add that entire sequence as a single element to the list. fruits = ['apple', 'banana'] fruits.append('orange') print(fruits) # ['apple', 'banana', 'orange'] nested_list = [1, 2] fruits.append(nested_list) print(fruits) # ['apple', 'banana', 'orange', [1, 2]..

Gain 1. 권력을 얻다. 2. 통제권을 얻다. 3. 접근할 수 있다. 4. 명성을 얻다. 5. 관심을 받다. 6. 인식을 가지다. 7. 장점을 갖다. 1. gain power 2. gain control 3. gain access 4. gain a reputation 5. gain publicity 6. gain recognition 7. gain an advantage Win 1. 수상하다. 2. 상을 타다. 3. 메달을 따다. 4. 게임에서 이기다. 5. 전쟁에서 이기다. 6. 선거에서 이기다. 1. win an award 2. win a prize 3. win a medal 4. win a game 5. win a war 6. win an election Make/ Earn, Achieve 1...

https://youtu.be/4b5d3muPQmA?si=sA0n1YrxFFx8YhNo 1. Select the number of clusters(=K) you want to identify in your data. 2. Randomly select 3 distinct data points. 3. Measure the distance between the 1st point and the three initial clusters. 4. Assign the 1st point to the nearest cluster. 5. Do the same thing for the remaining points. 6. Assess the quality of clustering by adding up the variatio..

Have 1. 사고가 나다 2. 말다툼을 하다/ 논쟁이 있다 3. 잠깐 쉬는시간을 갖다 4. 이야기하다 5. 어려움이 있다 6. 꿈/악몽을 꾸다 7. 경험이 있다 8. ~한 기분이 들다 9. 좋은 시간을 보내다 10. 살펴보다, 한번 보다 11. 파티를 하다 12. 문제가 있다, 어려움이 있다 13. 시도하다 1. have an accident 2. have an argument 3. have a break 4. have a chat/conversation 5. have difficulty 6. have a dream/nightmare 7. have an experience 8. have a feeling 9. have fun/ a good time 10. have a look 11. have a par..

Make * connected with saying things 1. 준비를 하다 2. 바꾸다, 변화를 주다 3. 결정하다, 선택하다 4. 말하다, 의견을 제시하다 5. 기여하다 6. 결정하다 7. 노력하다 8. 변명하다 9. 친구를 사귀다 10. 개선하다 11. 실수를하다 12. 전화하다 13. 진전이 있다 1. make arrangements for 2. make a change 3. make a choice 4. make a comment 5. make a contribution to 6. make a decision 7. make an effort 8. make an excuse 9. make friends 10. make an improvement 11. make a mistake 12. mak..

JOIN : combine information from multiple tables in one query JOIN 5줄 요약 조인은 두 개의 테이블을 서로 묶어서 하나의 결과를 만들어 내는 것을 말한다. INNER JOIN(내부 조인)은 두 테이블을 조인할 때, 두 테이블에 모두 지정한 열의 데이터가 있어야 한다. OUTER JOIN(외부 조인)은 두 테이블을 조인할 때, 1개의 테이블에만 데이터가 있어도 결과가 나온다. CROSS JOIN(상호 조인)은 한쪽 테이블의 모든 행과 다른 쪽 테이블의 모든 행을 조인하는 기능이다. SELF JOIN(자체 조인)은 자신이 자신과 조인한다는 의미로, 1개의 테이블을 사용한다. 1. Inner join Combin the two tables in one que..

1. Mathematical Functions and Operators Syntax SELECT film_id, rental_rate as old_rental_rate, CEILING(rental_rate * 1.1) as new_rental_rate FROM film https://www.postgresql.org/docs/16/functions-math.html 9.3. Mathematical Functions and Operators 9.3. Mathematical Functions and Operators # Mathematical operators are provided for many PostgreSQL types. For types without standard mathematical con..

6. EXTRACT Used to extract parts of timestamp/date Syntax EXTRACT (field from date/time/interval) SELECT EXTRACT(day from rental_date), COUNT(*) FROM rental GROUP BY EXTRACT(day from rental_date) ORDER BY COUNT(*) DESC * Challenge Write a query to find out the following: 1) What's the month with the highest total payment amount? 2) What's the day of week with the highest total payment amount?(0 ..

1. LOWER & UPPER, LENGTH Syntax SELECT LOWER (email) AS email_lower, email, LENGTH(email) FROM customer WHERE LENGTH(email) < 30 * Challenge Write a query to find customers whose either the first name or the last name is more than 10 characters long. Output the list of these first and last names in all lower case. SELECT LOWER(first_name), LOWER(last_name), LOWER(email) FROM customer WHERE LENGT..

1. Aggregate Functions Aggregate values in multiple rows to one value SUM, AVG, MIN, MAX, COUNT Syntax SELECT SUM (amount), ROUND(AVG (amount), 3) AS AVERAGE -- 3 decimal places FROM payment * Challenge Write a query to see the minimum, maximum, average(rounded), sum of the replacement cost of the films SELECT MIN (replacement_cost), MAX (replacement_cost), ROUND(AVG(replacement_cost), 3) AS AVG..