DevOps Engineer DevOps Engineer

pandas sqlite3

• [Python] sqlite3 DB output to pandas dataframe. (sqlite3 db 퀄리결과 pandas dataframe 만들기)

  Python/Python For Analytics 2019. 8. 12. 22:20

  import pandas as pd import sqlite3 conn = sqlite3.connect(DB PATH) query = "select columns from table " df = pd.read_sql_query(query,conn)

  Read More
• [Python] IIS log date Sqlite3 Memory DB and pandas DataFrame

  Python/Data Struc & algo 2018. 5. 24. 23:05

  - pandas.read_sql_query를 통해 쿼리의 결과값을 pandas DataFrame 가져올 수 있다 # 약 42만 라인의 IIS로그를 SQLite3 메모리DB로 생성하여 'scbytes', 'csbytes', 'timetaken' 컬럼을 pandas와 연동 pandas.read_sql_query(쿼리, conn) import sqlite3 from datetime import datetime import pandas as pd conn = sqlite3.connect(':memory:') c = conn.cursor() c.execute('''CREATE TABLE memorylogdb (date date, time time, sitename VARCHAR(50), computername V..

  Read More