|
Search Results
|
| Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
| |
|
Thread: run SQL without user intervention python
Post: run SQL without user intervention python
| Hello, Is possible connect SQL from python without using password and username in the script. But the script should run without user intervention. Exist some possibility? if yes is it the safe? I know... |
|
dawid294 |
General Coding Help |
0 |
247 |
Jan-19-2024, 01:11 PM |
| |
|
Thread: connect sql by python using txt. file
Post: connect sql by python using txt. file
| Hi python experts i do not know what i do wrong , I would like connect to sql by python using txt.file , Where i do a mistake? or is possible connect to sql by python so as not to be seen password and... |
|
dawid294 |
General Coding Help |
2 |
476 |
Jan-12-2024, 09:23 AM |
| |
|
Thread: This result object does not return rows. It has been closed automatically
Post: RE: This result object does not return rows. It ha...
| (Jan-10-2024, 08:39 PM)deanhystad Wrote: Go read this:
https://www.geeksforgeeks.org/connecting...qlalchemy/I red it , but problem is not how connect pandas with SQL , I know it , But when I use th... |
|
dawid294 |
General Coding Help |
6 |
1,171 |
Jan-10-2024, 08:50 PM |
| |
|
Thread: This result object does not return rows. It has been closed automatically
Post: RE: This result object does not return rows. It ha...
| (Jan-10-2024, 06:35 PM)deanhystad Wrote: Please post all the code.
I updated the code |
|
dawid294 |
General Coding Help |
6 |
1,171 |
Jan-10-2024, 08:04 PM |
| |
|
Thread: This result object does not return rows. It has been closed automatically
Post: This result object does not return rows. It has be...
| Hi colleagues, Can you help me with this? I know that here are the most of discussion about this problem, but i can not solve it. I red that i have to use SET NOCOUNT ON; but it does not work
this is ... |
|
dawid294 |
General Coding Help |
6 |
1,171 |
Jan-10-2024, 04:52 PM |
| |
|
Thread: use .sql instead of script
Post: use .sql instead of script
| Hi, I have one question , is possible to replace one thing on the script . I have the script. It works good, but i would like use text.sql intead of select tab.num from tabulka tab. Is it possible i... |
|
dawid294 |
General Coding Help |
0 |
311 |
Jan-08-2024, 12:09 PM |
| |
|
Thread: unexpected EOF while parsing
Post: unexpected EOF while parsing
| Please can you help me where is the issue ? i do not know what i do wrong. thanks
import cx_Oracle
try:
connection=cx_Oracle.connect("dw1","dw2","//local/DW3")
with connection.cursor(... |
|
dawid294 |
General Coding Help |
1 |
445 |
Jan-03-2024, 12:09 PM |
| |
|
Thread: __init__() got multiple values for argument 'schema'
Post: RE: __init__() got multiple values for argument 's...
| This is the code
# Import sqlalchemy's create_engine() function
from sqlalchemy import create_engine
import pandas as pd
# Create the database engine
engine = create_engine("oracle+cx_oracle://dw1:... |
|
dawid294 |
General Coding Help |
4 |
2,523 |
Jan-03-2024, 08:34 AM |
| |
|
Thread: __init__() got multiple values for argument 'schema'
Post: __init__() got multiple values for argument 'schem...
| Hi , which packages do you use when you have issue __init__() got multiple values for argument 'schema'. how can i solve this issue. Which packages will i use? Thanks |
|
dawid294 |
General Coding Help |
4 |
2,523 |
Jan-02-2024, 09:05 PM |
| |
|
Thread: plsql developer in python
Post: plsql developer in python
| I have the problem with my script. The script works good, but not for big script. I would like to use big SQL script with left join , inner join and etc. but after this script does not work. Why Can y... |
|
dawid294 |
General Coding Help |
0 |
364 |
Jan-02-2024, 03:23 PM |
| |
|
Thread: connection python and SQL
Post: RE: connection python and SQL
| ok i have created the code in PL/SQL developer where i download and edit the data, after that I save this data to excel and after that I start The code with model in python. I would like to improve th... |
|
dawid294 |
General Coding Help |
4 |
712 |
Dec-11-2023, 10:34 AM |
| |
|
Thread: connection python and SQL
Post: connection python and SQL
| Hi python experts, Is possible to connect Python and SQL? In jupyter notebook or in Pycharm? Is possible start the code from SQL in Python? If Yes how?Thanks |
|
dawid294 |
General Coding Help |
4 |
712 |
Dec-11-2023, 09:28 AM |
| |
|
Thread: group by create pivot table python
Post: group by create pivot table python
| Hello I searched how can i do this but i did not find anything. please Can you help me . I have data set with three columns. i would to create pivot table in python as in below . clusters are created... |
|
dawid294 |
General Coding Help |
1 |
1,317 |
Jun-22-2022, 03:42 PM |
| |
|
Thread: catboost
Post: catboost
| Hello can you help me , I tried install catboost but i have issue. I use jupyter notebook. Thank you
from catboost import CatBoostClassifier
from catboost import CatBoostRegressor
ModuleNotFoundErr... |
|
dawid294 |
General Coding Help |
1 |
2,376 |
Sep-10-2021, 07:19 AM |
| |
|
Thread: xgboost,halvinggridsearchcv hyperparameters
Post: xgboost,halvinggridsearchcv hyperparameters
| I am searching for best hyper parameters of XGBRegressor using HalvingGridSearchCV. Here is the code:
base_estimator = XGBRegressor(seed=1234,use_label_encoder=False,base_score=0.5,max_delta_step=0,
... |
|
dawid294 |
Data Science |
0 |
1,329 |
Sep-03-2021, 06:14 AM |
| |
|
Thread: quartile and average
Post: quartile and average
| Hello i need help with quartile in python
I have this data and i would like to create quartile from column NUMBER and average values from column expected. I can created quartile with this code
#df... |
|
dawid294 |
Data Science |
0 |
1,509 |
Mar-04-2021, 10:57 AM |
| |
|
Thread: multi np.where
Post: RE: multi np.where
| I found solution
MODEL1b.loc[(MODEL1b['PP']<20) & (MODEL1b['PP']>=10), 'cl'] = '10--20'
Thanks |
|
dawid294 |
Data Science |
2 |
2,403 |
Mar-04-2021, 10:42 AM |
| |
|
Thread: multi np.where
Post: multi np.where
| Hello guys. I need help. Can you help me with code. I have not found it anywhere. I use np.where but I would like to use np.where as if in excel. I need create clusters with amount. I have one column ... |
|
dawid294 |
Data Science |
2 |
2,403 |
Mar-01-2021, 02:17 PM |
| |
|
Thread: merge two dataframes with different number of rows
Post: RE: merge two dataframes with different number of ...
| I have already found a solution. thank you for your willingness. you can close the thread.
this is solution:
data1.index=data2.index
and after i can use
data= pd.concat([data1,data2],axis='1') |
|
dawid294 |
General Coding Help |
5 |
4,108 |
Feb-05-2021, 02:33 PM |
| |
|
Thread: merge two dataframes with different number of rows
Post: RE: merge two dataframes with different number of ...
| data1
car bus
0 1 8
1 9 5
2 1 8
3 2 8
4 3 8
5 6 5
data2
pay
300 1
345 2
854 8
12 9
69 10
data1=pd.dataframe(data1)
data2=pd.dataframe(data2)
data= pd.concat([data1,data2],axis='1')
print(data) |
|
dawid294 |
General Coding Help |
5 |
4,108 |
Feb-05-2021, 01:00 PM |
