bilgi=pd.read_sql_query("""SELECT kadi FROM uye WHERE rowid=1""",conn)
bu şekilde kullanınca
altta gördüğün resimde 2 adet veri çıkıyor bunların 1.sini nasıl alıcam, ben normalde şu şekilde çekiyordum.
list=cursor.fetchone()
uyeid=list[0]
ama bunda o şekilde vermedi.
Merhaba
################################################## ################################################## ######################
import pyodbc
import sqlalchemy as sal
from sqlalchemy import create_engine
import pandas as pd
import time
import datetime
import numpy as np
import warnings
warnings.filterwarnings("ignore")
from IPython.display import display
################################################## ################################################## ######################
conn_str = (
r'DRIVER={SQL Server Native Client 11.0};'
r'SERVER=RELATEDB03REPLICA;'
r'DATABASE=CENTRAL;'
r'Trusted_Connection=yes;'
)
cnxn = pyodbc.connect(conn_str)
df = pd.read_sql_query(
'''select * from [CENTRAL].[dbo].[FactAttrition]''', cnxn)
bu noktadan sonra df tablosunda pandas ile istedigin manipulasyonu yapabilirsin.