해결방법 >>> import pandas UserWarning: Could not import the lzma module. Your installed Python is incomplete. Attempting to use lzma compression will result in a RuntimeError. warnings.war...
[MySQL] Docker로 실행했을때 한글 깨짐
해결방법 # docker container docker run –name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password -d mysql:5.7 –character-set-server=utf8 –collation-server=utf8_unicode_ci # docker-compose version: '3...
[Python] Pandas DataFrame을 MySQL로 INSERT
Pandas Dataframe을 MySQL로 INSERT df = pd.read_csv('./data/preprocessed/apt-trade/11110/202106.csv') logger.info(df.head(10)) with connection: with connection.cursor() as cursor: # Crea...
[Python] Custom Logger
import logging def init_logger(name): logger=logging.getLogger(name) logger.setLevel(logging.DEBUG) #Creating Formatters formatter=logging.Formatter('%(asctime)s:%(levelname)s:...
[MySQL] Workbench UI Docker
Workbench version: "2.1" services: mysql-workbench: image: ghcr.io/linuxserver/mysql-workbench container_name: mysql-workbench environment: PUID: 1000 PGID: 1000 TZ...
[MySQL] 초기 작업
CREATE USER CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; CREATE USER 'play'@'localhost' IDENTIFIED BY 'play2'; 테이블 권한 grant all privileges on *.* to 'username'@'localhost'; gran...
[MySQL] M1에서 MySQL Docker 실행
Docker docker pull mysql Using default tag: latest latest: Pulling from library/mysql no matching manifest for linux/arm64/v8 in the manifest list entries M1 진짜 빡 docker pull --platform lin...
[Git] Passwd가 아닌 Token 방식으로 변경
remote: Support for password authentication was removed on August 13, 2021. Please use a personal access token instead. [Profile] - [Setting] - [Developer Settings] - [Personal Access Token] 비밀번...
[Tensorflow] Wide&Deep, Deep&Cross 모델 생성
Wide & Depp wide = layers.BatchNormalization()(wide) for units in hidden_units: deep = layers.Dense(units)(deep) deep = layers.BatchNormalization()(deep) deep = layers.ReLU()(deep)...
[Tensorflow] DNN 모델
model = tf.keras.Sequential([ input_layers, layers.Dense(1024, activation='relu'), layers.BatchNormalization(), layers.Dense(512, activation='relu'), layers.BatchNormalization()...