Spaces:
Sleeping
Sleeping
File size: 557 Bytes
dea8fe5 7ff3acf dea8fe5 7ff3acf dea8fe5 7ff3acf |
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 os
import sqlite3
import pandas as pd
# DB_PATH = r"E:/Healthcare_chat_AI/data/veludb.db"
DB_PATH = f"{os.path.dirname(os.path.dirname(os.path.dirname(__file__)))}/data/veludb.db"
# print(DB_PATH)
# print("Database exists:", os.path.exists(DB_PATH))
def fetch_data():
conn = sqlite3.connect(DB_PATH)
query = "SELECT * FROM healthcare_data;" # Fetch 5 rows
df = pd.read_sql(query, conn)
conn.close()
return df
df =fetch_data()
df.drop_duplicates(inplace=True)
# print(df) # Display the first 5 rows
|