Data Science
파이썬으로 음악 파일 자르기
from pydub import AudioSegment import math song = AudioSegment.from_mp3("1.mp3") sixty_seconds = 60 * 1000 for i in range(int(math.floor(len(song)/60000))): slice = song[i*sixty_seconds:sixty_seconds*(i+1)] slice.export('newSong_{}.mp3'.format(i), format="mp3") 원본파일: 1.mp3을 1분단위로 자르는 코드 pydub의 AudioSegment를 사용하였음
Matrix Calculations, Eigen Vector
Q1. Let M be the following matrix: (a) Find the inverse of M. To find the inverse of M, we need to find det(A). det(A) = ad - bc where det(A) = ad - bc = (2*1) - (-3)(-2) = (2)-(6) = -4 Then, rearrange M Multiply by 1/det(A) This gives M^-1 of: (b) Using your answer to (a) or otherwise, find the solution to the following system of equations: 2 ways of solving this question. 1) Using M^-1 2) Usin..
리눅스 디렉토리 구조
Linux Directory Structure Most Linux-like OS uses FHF(Filesystem Hierarchy Standard) structure. This means files are categorized and stored into different folders under ROOT(/) directory, based on their types, usage and purpose. In usual cases those directories are: /bin, /sbin, /etc, /boot, /mnt, /usr, /lib, /home, /dev, /proc, /var, /tmp, /opt, /media 1. / Root Directory는 리눅스 시스템에서 최상위 디렉토리이다...
Transaction Management
What does it mean by ACID properties in database transaction? Atomicity: All database operations of a transaction must be entirely completed or entirely aborted. Consistency: It must take the database from one consistent state to another. i.e. If DB goes down during the transaction, it should revert back to the original starting state. Isolation: Data used during execution cannot be used by the ..
Python으로 코스피 지수 불러오기
우선 pandas-datareader를 설치해야한다. 설치방법은 Windows 검색 - cmd - 관리자 권한으로 실행 - 아래 명령어 입력 pip install pandas-datareader - Pandas Datareader library를 이용, 야후에서 2007년 1월1일부터 2017년 10월31일까지 KOSPI index를 불러옴 - 종가의 Median과, descriptive statistics, correlation을 구하고 line차트를 그렸음 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 import pandas_datareader as wb import pandas as pd import datetime import m..