목록Python (125)

무회 Blog

python: 200529-python_문서내 단어 빈도 분석

import pandas as pd from konlpy.tag import Kkma from konlpy.utils import pprint kkma = Kkma() f = open('C:\\Users\\user\\Documents\\PythonTest\\Data\\문재인대통령취임연설문.txt', 'r') lines = f.readlines() f.close() # 형태소 분석하여 명사만 추출 temp = [] for i in range(len(lines)): temp.append(kkma.nouns(lines[i])) def flatten(l): flatList = [] for elem in l: if type(elem) == list: for e in elem: flatList.append(e) e..
Python 2020. 5. 29. 19:28
python: 200529-python-test002ldaModel-토픽추출

from gensim import corpora from gensim.models import LsiModel from gensim.parsing.preprocessing import preprocess_string import re def clean_text(x): pattern = r'[^a-zA-Z0-9\s]' text = re.sub(pattern,'',x) return x def clean_numbers(x): if bool(re.search(r'\d',x)): x = re.sub('[0-9]{5,}','#####',x) x = re.sub('[0-9]{4,}','####',x) x = re.sub('[0-9]{3,}','###',x) x = re.sub('[0-9]{2,}','##',x) re..
Python 2020. 5. 29. 19:27
python: 200529-python-test001 ldaModel-토픽추출

import numpy as np import pandas as pd import matplotlib.font_manager as fm import matplotlib.pyplot as plt from future.utils import iteritems from sklearn.manifold import TSNE from sklearn.feature_extraction.text import TfidfVectorizer from sklearn.feature_extraction.text import CountVectorizer from string import punctuation from collections import Counter from gensim import corpora from gensim..
Python 2020. 5. 29. 19:27
python:200526-pyDB_ver001.02, - insert 다건 , executemany()

from excel to oracle table dbcode 01 CREATE TABLE "PYTEST001"."VITA5" ("GN_NM" VARCHAR2(20 BYTE) NOT NULL ENABLE, "GN_MEMO" VARCHAR2(20 BYTE) NOT NULL ENABLE, "GN_EVALUATION" VARCHAR2(4000 BYTE), "GN_CONTENT" VARCHAR2(4000 BYTE), "GN_DATE" DATE, "GN_EVALUATIONCOUNT" NUMBER(5,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEX..
Python 2020. 5. 26. 16:31
python:200526-pyDB-001.003, insert, 단건(oracle)

# DB-003, python DB insert import pandas as pd import cx_Oracle import time # conn=cx_Oracle.connect("scott/tiger@192.168.182.1:1521/xe") # def save_data(): db = conn=cx_Oracle.connect("scott/tiger@192.168.182.1:1521/xe") try: cr = db.cursor() except: print('database connection faile') # # insert into emp( # EMPNO =7500 # ENAME ='ALLEN' # JOB ='SALESMAN' # MGR =7698 # HIREDATE ='SYSDATE' # SAL =..
Python 2020. 5. 25. 20:10
Prev 1 ··· 17 18 19 20 21 22 23 ··· 25 Next