2015. 8. 23. 18:21
Machine Learning & Data Mining

Numpy Install (펌, 조대협블로그)

Numpy Install

참고

머신러닝이나 빅데이타 분석을 위해서는 NumPy 뿐만 아니라 matplot등 다양한 수학 모듈을 깔아야 하는데, 방화벽등이 있거나 하면 깔기가 매우 까다롭다. (의존성 관계도 복잡하고). 그래서 수학용 모듈을 모아 놓은 파이썬 인스톨패키지가 있다. http://www.scipy.org/install.html

처음부터 이걸로 까는게 시간을 절약할 수 있는 방법일듯



저작자표시 비영리

'Machine Learning & Data Mining' 카테고리의 다른 글

나이브 베이즈 분류 (Naive Bayesian classification) #1 - 소개 (펌, 조대협 블로그)  (0) 2015.08.23
머신러닝 개념 소개 및 kNN 알고리즘 소개 (펌, 조대협 블로그)  (0) 2015.08.23
머신러닝 프레임웍에 대한 간단 메모 (펌, 조대협 블로그)  (0) 2015.08.23
맨땅에 해딩 머신러닝 #2 - 선형 회귀 모델 (1) (펌, 조대협 블로그)  (0) 2015.08.23
맨땅에 해딩 머신러닝 #1-기본 개념 잡기 (펌, 조대협 블로그)  (0) 2015.08.23
Posted by Name_null
2015. 8. 23. 18:19
Machine Learning & Data Mining

맨땅에 해딩 머신러닝 #2 - 선형 회귀 모델 (1) (펌, 조대협 블로그)

맨땅에 해딩 머신러닝 #2 - 선형 회귀 모델 (1)

Hypothesis(추론)는 추론 알고리즘의 집합으로, Hypothesis h는 Feature를 넣으면 Targeted value를 계산 해주는 일종의 공식이다.

실제 아파트 평수 x’을 넣으면 예측되는 가격 y’을 리턴해주는 개념인데, 이 Hypothesis h는 말 그대로 추론 값으로 어떤 정확한 예측 가격이 있을 수 없다. 다만 예측의 정확도를 높이는 것이 머신 러닝인데, Training Set을 러닝 알고리즘 (Learning Algorithm)을 이용하여 지속적으로 학습을 하여 최적의 h를 찾는 것이 머신 러닝이다.






맨땅에 해딩 머신러닝 #2 - 선형 회귀 모델 (1)


저작자표시 비영리

'Machine Learning & Data Mining' 카테고리의 다른 글

나이브 베이즈 분류 (Naive Bayesian classification) #1 - 소개 (펌, 조대협 블로그)  (0) 2015.08.23
머신러닝 개념 소개 및 kNN 알고리즘 소개 (펌, 조대협 블로그)  (0) 2015.08.23
머신러닝 프레임웍에 대한 간단 메모 (펌, 조대협 블로그)  (0) 2015.08.23
Numpy Install (펌, 조대협블로그)  (0) 2015.08.23
맨땅에 해딩 머신러닝 #1-기본 개념 잡기 (펌, 조대협 블로그)  (0) 2015.08.23
Posted by Name_null
2015. 8. 23. 18:17
Machine Learning & Data Mining

맨땅에 해딩 머신러닝 #1-기본 개념 잡기 (펌, 조대협 블로그)

맨땅에 해딩 머신러닝 #1-기본 개념 잡기



머신 러닝 이란?


컴퓨터에 샘플 데이터를 통한 지속적인 학습을 통해서, 문제에 대한 답을 얻어내는 방법

컴퓨터 공학, 수학, 통계학의 교집합에 속함. 쉽게 접할 수 있는 머신러닝의 사례로는 

  • 이메일 스팸 필터링 시스템
  • 쇼핑몰이나 영화 연관 추천 시스템
  • 문자 인식
  • 자연어 처리
  • 연관 검색어 처리



맨땅에 해딩 머신러닝 #1-기본 개념 잡기


저작자표시 비영리

'Machine Learning & Data Mining' 카테고리의 다른 글

나이브 베이즈 분류 (Naive Bayesian classification) #1 - 소개 (펌, 조대협 블로그)  (0) 2015.08.23
머신러닝 개념 소개 및 kNN 알고리즘 소개 (펌, 조대협 블로그)  (0) 2015.08.23
머신러닝 프레임웍에 대한 간단 메모 (펌, 조대협 블로그)  (0) 2015.08.23
Numpy Install (펌, 조대협블로그)  (0) 2015.08.23
맨땅에 해딩 머신러닝 #2 - 선형 회귀 모델 (1) (펌, 조대협 블로그)  (0) 2015.08.23
Posted by Name_null
2015. 6. 21. 00:02
SQL

W3Schools SQL Quiz

http://www.w3schools.com/quiztest/quiztest.asp?qtest=SQL




SQL QUIZPoints: 20 out of 25

1. What does SQL stand for?

You answered:

Structured Query Language

 Correct Answer!

2. Which SQL statement is used to extract data from a database?

You answered:

SELECT

 Correct Answer!

3. Which SQL statement is used to update data in a database?

You answered:

UPDATE

 Correct Answer!

4. Which SQL statement is used to delete data from a database?

You answered:

REMOVE

 Wrong Answer!

5. Which SQL statement is used to insert new data in a database?

You answered:

INSERT INTO

 Correct Answer!

6. With SQL, how do you select a column named "FirstName" from a table named "Persons"?

You answered:

 Wrong Answer!

7. With SQL, how do you select all the columns from a table named "Persons"?

You answered:

SELECT * FROM Persons

 Correct Answer!

8. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

You answered:

SELECT * FROM Persons WHERE FirstName='Peter'

 Correct Answer!

9. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

You answered:

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

 Correct Answer!

10. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

You answered:

True

 Correct Answer!

11. With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

You answered:

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

 Correct Answer!

12. With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

You answered:

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

 Correct Answer!

13. Which SQL statement is used to return only different values?

You answered:

SELECT DISTINCT

 Correct Answer!

14. Which SQL keyword is used to sort the result-set?

You answered:

ORDER BY

 Correct Answer!

15. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

You answered:

SELECT * FROM Persons ORDER BY FirstName DESC

 Correct Answer!

16. With SQL, how can you insert a new record into the "Persons" table?

You answered:

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

 Wrong Answer!

17. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

You answered:

INSERT ('Olsen') INTO Persons (LastName)

 Wrong Answer!

18. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

You answered:

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

 Wrong Answer!

19. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

You answered:

DELETE FROM Persons WHERE FirstName = 'Peter'

 Correct Answer!

20. With SQL, how can you return the number of records in the "Persons" table?

You answered:

SELECT COUNT(*) FROM Persons

 Correct Answer!

21. What is the most common type of join?

You answered:

INNER JOIN

 Correct Answer!

22. Which operator is used to select values within a range?

You answered:

BETWEEN

 Correct Answer!

23. The NOT NULL constraint enforces a column to not accept null values.

You answered:

True

 Correct Answer!

24. Which operator is used to search for a specified pattern in a column?

You answered:

LIKE

 Correct Answer!

25. Which SQL statement is used to create a table in a database?

You answered:

CREATE TABLE

 Correct Answer!


저작자표시 비영리

'SQL' 카테고리의 다른 글

Hosting  (0) 2015.06.20
Quick Reference From W3Schools  (0) 2015.06.20
FORMAT() Function  (0) 2015.06.20
NOW() Function  (0) 2015.06.20
ROUND() Function  (0) 2015.06.20
Posted by Name_null
2015. 6. 20. 23:51
SQL

Hosting

 

SQL Hosting

If you want your web site to be able to store and retrieve data from a database, your web server should have access to a database-system that uses the SQL language.

If your web server is hosted by an Internet Service Provider (ISP), you will have to look for SQL hosting plans.

The most common SQL hosting databases are MS SQL Server, Oracle, MySQL, and MS Access.

MS SQL Server

Microsoft's SQL Server is a popular database software for database-driven web sites with high traffic.

SQL Server is a very powerful, robust and full featured SQL database system.

Oracle

Oracle is also a popular database software for database-driven web sites with high traffic.

Oracle is a very powerful, robust and full featured SQL database system.

MySQL

MySQL is also a popular database software for web sites.

MySQL is a very powerful, robust and full featured SQL database system.

MySQL is an inexpensive alternative to the expensive Microsoft and Oracle solutions.

Access

When a web site requires only a simple database, Microsoft Access can be a solution.

Access is not well suited for very high-traffic, and not as powerful as MySQL, SQL Server, or Oracle.



저작자표시 비영리

'SQL' 카테고리의 다른 글

W3Schools SQL Quiz  (0) 2015.06.21
Quick Reference From W3Schools  (0) 2015.06.20
FORMAT() Function  (0) 2015.06.20
NOW() Function  (0) 2015.06.20
ROUND() Function  (0) 2015.06.20
Posted by Name_null

티스토리툴바