티스토리

날아보자!

검색하기

블로그 홈

날아보자!

hoojiv.tistory.com/m

Restart!!

구독자: 0

방명록 방문하기

주요 글 목록

[Database] 데이터 관련 용어 정리 주제영역 기업이 사용하는 데이터의 최상위 집합으로 동일한 기능을 하는 데이터를 그룹으로 정의하여 관리하는 것을 의미한다. 하나의 주제영역으로 정의되는 데이터간의 관계는 밀접하고, 다른 주제 영역에 포함되는 데이터 간의 상호작은 최소화하도록 정의해야 한다. 제조업의 경우 인사, 생산, 판매, 자재 등으로 구성될 수 있다. https://dataonair.or.kr/db-tech-reference/d-guide/da-guide/?mod=document&uid=280 주제 영역 정의 주제 영역 개념 주제 영역(Subject Area)은 기업이 사용하는 데이터의 최상위 집합이다. 예를 들어, 제조 업체의 경우 인사, 생산, 자재, 판매 등의 주제 영역이 있을 수 있다. 하나의 주제 영역으로 dataonair.o.. 공감수 0 댓글수 0 2022. 1. 15.
[Python/Basic] 기본구문 (주석,변수,랜덤함수,타입변환,String,Boolean,연산자) 주석 # 한줄 주석 """ 여러줄 주석 """ 변수 # 타입변환 x = str(3) # x will be '3' y = int(3) # y will be 3 z = float(3) # z will be 3.0 # 변수타입확인 x = 5 y = "John" print(type(x))# print(type(y))# # 값할당 x = y = z = "Orange" print(x)# Orange print(y)# Orange print(z) # Orange # 여러값할당 x, y, z = "Orange", "Banana", "Cherry" print(x)# Orange print(y)# Banana print(z)# Cherry # 리스트할당 fruits = ["apple", "banana", "cherry"].. 공감수 0 댓글수 0 2021. 12. 28.
[Python/Tensorflow] Install & Hello World! Install Tensorflow는 python 명령어를 사용하여 install이 가능하다. > pip3 install tensorflow 혹시 install이 되지 않는다면 python 버전 문제일 수 있다. 3.10 버전에서는 tensorflow 제공이 되지 않기 때문에 3.9로 재설치하였다...ㅠ https://hoojiv.tistory.com/95 [Python/Tutorial따라하기] python install python 다운로드 https://www.python.org/downloads/ Download Python The official home of the Python Programming Language www.python.org 링크로 들어가니 바로 windows용 최신 버전을 보여주.. 공감수 0 댓글수 0 2021. 12. 24.
[Python/Hackerrank] Strings > Capitalize! Capitalize! You are asked to ensure that the first and last names of people begin with a capital letter in their passports. For example, alison heck should be capitalised correctly as Alison Heck. Given a full name, your task is to capitalize the name appropriately. Input Format A single line of input containing the full name, S. Constraints The string consists of alphanumeric characters and spa.. 공감수 0 댓글수 0 2021. 12. 14.
[Python/Hackerrank] Strings > Alphabet Rangoli Alphabet Rangoli You are given an integer, N. Your task is to print an alphabet rangoli of size N. (Rangoli is a form of Indian folk art based on creation of patterns.) Different sizes of alphabet rangoli are shown below: #size 3 ----c---- --c-b-c-- c-b-a-b-c --c-b-c-- ----c---- #size 5 --------e-------- ------e-d-e------ ----e-d-c-d-e---- --e-d-c-b-c-d-e-- e-d-c-b-a-b-c-d-e --e-d-c-b-c-d-e-- --.. 공감수 0 댓글수 0 2021. 12. 10.
[Python/Hackerrank] Strings > String Formatting String Formatting Given an integer, n, print the following values for each integer i from 1 to n: Decimal Octal Hexadecimal (capitalized) Binary Function Description Complete the print_formatted function in the editor below. print_formatted has the following parameters: int number: the maximum value to print Prints The four values must be printed on a single line in the order specified above for.. 공감수 0 댓글수 0 2021. 12. 10.
[Python/Hackerrank] Strings > Designer Door Mat Designer Door Mat Mr. Vincent works in a door mat manufacturing company. One day, he designed a new door mat with the following specifications: Mat size must be N X M. (N is an odd natural number, and M is 3 times N.) The design should have 'WELCOME' written in the center. The design pattern should only use |, . and - characters. Sample Designs Size: 7 x 21 ---------.|.--------- ------.|..|..|.-.. 공감수 0 댓글수 0 2021. 12. 10.
[Python/Hackerrank] Strings > Text Wrap Text Wrap Check Tutorial tab to know how to to solve. You are given a string S and width W. Your task is to wrap the string into a paragraph of width W. Function Description Complete the wrap function in the editor below. wrap has the following parameters: string string: a long string int max_width: the width to wrap to Returns string: a single string with newline characters ('\n') where the bre.. 공감수 0 댓글수 0 2021. 12. 9.
[Python/Hackerrank] Strings > Text Alignment Text Alignment In Python, a string of text can be aligned left, right and center. .ljust(width) This method returns a left aligned string of length width. >>> width = 20 >>> print 'HackerRank'.ljust(width,'-') HackerRank---------- .center(width) This method returns a centered string of length width. >>> width = 20 >>> print 'HackerRank'.center(width,'-') -----HackerRank----- .rjust(width) This m.. 공감수 0 댓글수 0 2021. 12. 9.
[Python/Hackerrank] Strings > String Validators String Validators Python has built-in string validation methods for basic data. It can check if a string is composed of alphabetical characters, alphanumeric characters, digits, etc. str.isalnum() This method checks if all the characters of a string are alphanumeric (a-z, A-Z and 0-9). >>> print 'ab123'.isalnum() True >>> print 'ab123#'.isalnum() False str.isalpha() This method checks if all the.. 공감수 0 댓글수 0 2021. 12. 9.
[Python/Hackerrank] Strings > Find a string Find a string In this challenge, the user enters a string and a substring. You have to print the number of times that the substring occurs in the given string. String traversal will take place from left to right, not from right to left. NOTE: String letters are case-sensitive. Input Format The first line of input contains the original string. The next line contains the substring. Constraints Eac.. 공감수 0 댓글수 0 2021. 12. 8.
[Python/Hackerrank] Strings > Mutations Mutations We have seen that lists are mutable (they can be changed), and tuples are immutable (they cannot be changed). Let's try to understand this with an example. You are given an immutable string, and you want to make changes to it. Example >>> string = "abracadabra" You can access an index by: >>> print string[5] a What if you would like to assign a value? >>> string[5] = 'k' Traceback (mos.. 공감수 0 댓글수 0 2021. 12. 8.
[Python/Hackerrank] Strings > What's Your Name? What's Your Name? You are given the firstname and lastname of a person on two different lines. Your task is to read them and print the following: Hello firstname lastname! You just delved into python. Function Description Complete the print_full_name function in the editor below. print_full_name has the following parameters: string first: the first name string last: the last name Prints string: .. 공감수 0 댓글수 0 2021. 12. 8.
[Python/Hackerrank] Strings > String Split and Join String Split and Join In Python, a string can be split on a delimiter. Example: >>> a = "this is a string" >>> a = a.split(" ") # a is converted to a list of strings. >>> print a ['this', 'is', 'a', 'string'] Joining a string is simple: >>> a = "-".join(a) >>> print a this-is-a-string Task You are given a string. Split the string on a " " (space) delimiter and join using a - hyphen. Function Des.. 공감수 0 댓글수 0 2021. 12. 8.
[Python/Hackerrank] Strings > sWAP cASE sWAP cASE You are given a string and your task is to swap cases. In other words, convert all lowercase letters to uppercase letters and vice versa. For Example: Www.HackerRank.com → wWW.hACKERrANK.COM Pythonist 2 → pYTHONIST 2 Function Description Complete the swap_case function in the editor below. swap_case has the following parameters: string s: the string to modify Returns string: the modifi.. 공감수 0 댓글수 0 2021. 12. 8.
[Python/Hackerrank] Basic Data Types > Tuples Tuples Task Given an integer, n, and n space-separated integers as input, create a tuple, t, of those n integers. Then compute and print the result of hash(t). Note: hash() is one of the functions in the __builtins__ module, so it need not be imported. Input Format The first line contains an integer, n, denoting the number of elements in the tuple. The second line contains n space-separated inte.. 공감수 0 댓글수 0 2021. 12. 8.
[Python/Hackerrank] Basic Data Types > Lists Lists onsider a list (list = []). You can perform the following commands: insert i e: Insert integer e at position i. print: Print the list. remove e: Delete the first occurrence of integer e. append e: Insert integer e at the end of the list. sort: Sort the list. pop: Pop the last element from the list. reverse: Reverse the list. Initialize your list and read in the value of n followed by n lin.. 공감수 0 댓글수 0 2021. 12. 8.
[Python/Hackerrank] Basic Data Types > Finding the percentage Finding the percentage The provided code stub will read in a dictionary containing key/value pairs of name:[marks] for a list of students. Print the average of the marks array for the student name provided, showing 2 places after the decimal. Example Input Format The first line contains the integer n, the number of students' records. The next n lines contain the names and marks obtained by a stu.. 공감수 0 댓글수 0 2021. 12. 7.
[Python/Hackerrank] Basic Data Types > Nested Lists Nested Lists Given the names and grades for each student in a class of N students, store them in a nested list and print the name(s) of any student(s) having the second lowest grade. Note: If there are multiple students with the second lowest grade, order their names alphabetically and print each name on a new line. Example records = [["chi", 20.0], ["beta", 50.0], ["alpha", 50.0]] The ordered l.. 공감수 0 댓글수 0 2021. 12. 6.
[Python/Hackerrank] Basic Data Types > Find the Runner-Up Score! Find the Runner-Up Score! Given the participants' score sheet for your University Sports Day, you are required to find the runner-up score. You are given n scores. Store them in a list and find the score of the runner-up. Input Format The first line contains . The second line contains an array A[] of n integers each separated by a space. Constraints 2 공감수 0 댓글수 0 2021. 12. 6.
[Python/Hackerrank] Basic Data Types > List Comprehensions List Comprehensions Let's learn about list comprehensions! You are given three integers x, y and z representing the dimensions of a cuboid along with an integer n. Print a list of all possible coordinates given by (i, j, k) on a 3D grid where the sum of i + j + k is not equal to n. Here, 0 공감수 0 댓글수 0 2021. 12. 6.
[Python/Tutorial따라하기] python install python 다운로드 https://www.python.org/downloads/ Download Python The official home of the Python Programming Language www.python.org 링크로 들어가니 바로 windows용 최신 버전을 보여주었다. 정상적으로 설치가 된 경우 cmd.exe 프롬프트로 들어가서 아래처럼 입력하면 설치된 버전이 출력된다. > python --version 21.12.24 내용추가 python 처음 다운로드 시 가장 처음에 보이는 lastest version인 3.10.0을 다운로드 받았지만, 나중에 tensorflow 설치를 위해 찾아보니 python 3.6~3.9까지에서 지원이 된다고 한다. 그래서 python 3.9.9 win.. 공감수 0 댓글수 0 2021. 12. 6.
[Python/Hackerrank] Introduction Say "Hello, World!" With Python Here is a sample line of code that can be executed in Python: print("Hello, World!") You can just as easily store a string as a variable and then print it to stdout: my_string = "Hello, World!" print(my_string) The above code will print Hello, World! on your screen. Try it yourself in the editor below! Input Format You do not need to read any input in this challen.. 공감수 0 댓글수 0 2021. 12. 6.
[Scrap] 학습사이트 #DACON https://dacon.io/hackathon 교육 - DACON 4만 AI팀이 협업하는 인공지능 플랫폼 dacon.io 공감수 0 댓글수 0 2021. 11. 20.
[Database] 기술면접 관련 한번 읽어보려고 스크랩 DataBase 데이터베이스 기본 용어 Key(키) SQL Injection SQL - Join SQL vs NoSQL 이상(Anomaly) 인덱스(INDEX) 트랜잭션 트랜잭션 격리수준 https://github.com/WooVictory/Ready-For-Tech-Interview GitHub - WooVictory/Ready-For-Tech-Interview: 💻 신입 개발자로서 준비를 하기 위해 지식을 정리하는 공간 💻 신입 개발자로서 준비를 하기 위해 지식을 정리하는 공간 👨‍💻. Contribute to WooVictory/Ready-For-Tech-Interview development by creating an account on GitHub. github.com I.. 공감수 0 댓글수 0 2021. 11. 20.
[MySQL] RANK(), DENSE_RANK(), ROW_NUMBER() 시스템 함수를 SQL로 구현하는 방법 RANK(), DENSE_RANK(), ROW_NUMBER() 시스템 함수를 SQL로 구현하는 방법 https://kimdubi.github.io/mysql/mysql_window_function/ MySQL5.7에서 window function 구현하기 MySQL5.7 에서 Window function 구현하기 MySQL 8.0 부터는 rank() over , dense 등 window 함수를 지원하지만 그 이전버전에서는 window 함수를 지원하지 않기 때문에 @rownum 같은 사용자변수를 활용해서 구현해야 kimdubi.github.io 공감수 0 댓글수 0 2021. 11. 17.
[programmers] MySQL 코딩연습 자주 사용하지 않는 구문에 대해서만 참고용으로 작성하였다. 입양 시각 구하기(1) 보호소에서는 몇 시에 입양이 가장 활발하게 일어나는지 알아보려 합니다. 09:00부터 19:59까지, 각 시간대별로 입양이 몇 건이나 발생했는지 조회하는 SQL문을 작성해주세요. 이때 결과는 시간대 순으로 정렬해야 합니다. https://programmers.co.kr/learn/courses/30/lessons/59412 SELECT HOUR(DATETIME), COUNT(*) FROM ANIMAL_OUTS WHERE HOUR(DATETIME) BETWEEN '9' AND '20' GROUP BY HOUR(DATETIME) ORDER BY HOUR(DATETIME) * MySQL의 날짜타입에서 시간만 가져오고 싶을 때는 .. 공감수 0 댓글수 0 2021. 11. 14.
[Database] sqltest.net SQL를 테스트해 볼 수 있는 사이트라고 한다. https://sqltest.net/ SQL Test Free Online SQL Test Tool sqltest.net 테스트 기능은 아직 사용해보진 않았고 각 DBMS별로 function를 설명해 놓은 부분이 마음에 들었다. MySQL Numeric Functions and Operators %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return the arc cosine ASIN.. 공감수 0 댓글수 0 2021. 11. 14.
[LeetCode] MySQL 코딩연습 LeetCode에 있는 MySQL 문제를 풀어볼 예정이다. 문제를 다 적는것은 어렵고 문제 이름과 코드 링크만 남기려고 한다. 해커랭크보다 훨씬 UI가 편한 느낌..!! 175. Combine Two Tables Write an SQL query to report the first name, last name, city, and state of each person in the Person table. If the address of a personId is not present in the Address table, report null instead. Return the result table in any order. https://leetcode.com/problems/combine-two-tabl.. 공감수 1 댓글수 0 2021. 11. 13.
[MS SQL SERVER] 기본적인 DDL 구문 정리 데이터베이스 /* Database 생성 */ CREATE DATABASE UserTemp; /* Database List 출력 */ EXEC sp_databases; /* Database 삭제 */ IF EXISTS(select * from sys.databases where name='UserTemp') DROP DATABASE UserTemp 테이블 /* 테이블 생성 */ USE UserLabs; GO CREATE TABLE dbo.UserTbl ( USERID INT PRIMARY KEY IDENTITY (1, 1), NAME VARCHAR(10), AGE INT, ADDR VARCHAR(20) ) CREATE TABLE dbo.UserSales ( USERID INT PRIMARY KEY IDEN.. 공감수 0 댓글수 0 2021. 11. 8.

문의안내

티스토리
로그인
고객센터

티스토리는 카카오에서 사랑을 담아 만듭니다.