Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: Win or Loss Prediction
Post: RE: Win or Loss Prediction
I used the below sample code (given only some part). Imported the data from excel and dropped few cols, just had the data as per attached file. Created train and test data and tried out Logistic, SVC ... |
|
ksasi2k3 |
General Coding Help |
4 |
230 |
Apr-25-2024, 01:46 PM |
|
|
Thread: Win or Loss Prediction
Post: RE: Win or Loss Prediction
(Apr-24-2024, 07:58 PM)deanhystad Wrote: Can you provide an example of what you tried?
Yes I have attached a sample data.. need to predict the Dealstate whether Won or Lost for the open state |
|
ksasi2k3 |
General Coding Help |
4 |
230 |
Apr-25-2024, 07:06 AM |
|
|
Thread: Win or Loss Prediction
Post: Win or Loss Prediction
I am trying to predict win or loss in ML using Python. Tried XGboost,Logistic and SVC method but getting struct in place where it says " estimators failed to fit".
Need help on this prediction.
I hav... |
|
ksasi2k3 |
General Coding Help |
4 |
230 |
Apr-24-2024, 06:45 PM |
|
|
Thread: To Copy text values to Excel using Python
Post: RE: To Copy text values to Excel using Python
Thank you heiner55 , XLWINGS library solved the problem |
|
ksasi2k3 |
General Coding Help |
16 |
15,891 |
Jun-26-2019, 01:23 PM |
|
|
Thread: To Copy text values to Excel using Python
Post: RE: To Copy text values to Excel using Python
Hi,
I am able to write without removing formulas using XLwings
here is the code:
import xlwings as xw
wb = xw.Book('C:/Users/Template v5.xlsx')
sht = wb.sheets['lity']
Now I need to loop this... |
|
ksasi2k3 |
General Coding Help |
16 |
15,891 |
Jun-14-2019, 11:19 AM |
|
|
Thread: To Copy text values to Excel using Python
Post: RE: To Copy text values to Excel using Python
Hi heiner55, I have done this already and I am able to copy the value from Text to excel when mentioning "data_only= True".
But I need to populate without this option because, when I use this "data_on... |
|
ksasi2k3 |
General Coding Help |
16 |
15,891 |
Jun-11-2019, 07:33 AM |
|
|
Thread: To Copy text values to Excel using Python
Post: RE: To Copy text values to Excel using Python
Let me explain in step by step process.
1.I have an excel file with formulas included in columns.
2.I want to paste the values from txt file to excel file.
3.I have a column name "Text file" in the e... |
|
ksasi2k3 |
General Coding Help |
16 |
15,891 |
Jun-07-2019, 03:45 PM |
|
|
Thread: To Copy text values to Excel using Python
Post: RE: To Copy text values to Excel using Python
It is the same excel file which acts as Input and output. For your reference I am attaching it with slightly modified and included formulas. "Sample.xlsx" is the input and output file.[attachment=660] |
|
ksasi2k3 |
General Coding Help |
16 |
15,891 |
Jun-07-2019, 03:29 PM |
|
|
Thread: To Copy text values to Excel using Python
Post: RE: To Copy text values to Excel using Python
Hi heiner55, Sample.xlsx is the resulting file. |
|
ksasi2k3 |
General Coding Help |
16 |
15,891 |
Jun-06-2019, 11:16 AM |
|
|
Thread: To Copy text values to Excel using Python
Post: RE: To Copy text values to Excel using Python
Thank you heiner55 for your reply.
I have attached example files.
I have a text file 12.txt as attached, I want to insert the values in this file to attached excel and in column "C" named as Finalto... |
|
ksasi2k3 |
General Coding Help |
16 |
15,891 |
Jun-03-2019, 04:07 PM |
|
|
Thread: To Copy text values to Excel using Python
Post: To Copy text values to Excel using Python
I am using Python to copy values from Text file to excel, able to succeed in that but the problem is that when pasting values to excel the existing formulas are removed.
I am using "import openpyxl" ... |
|
ksasi2k3 |
General Coding Help |
16 |
15,891 |
May-31-2019, 04:44 PM |
|
|
Thread: OOC
Post: OOC
Any suggestion for tool that exactly gives the cause and eliminates out of control from a control chart. |
|
ksasi2k3 |
General Coding Help |
0 |
1,945 |
Jul-26-2018, 02:18 PM |
|
|
Thread: Control chart in Python
Post: RE: Control chart in Python
Any idea.. I am really struggling with this, need to complete ASAP |
|
ksasi2k3 |
Data Science |
6 |
90,765 |
Jul-12-2018, 04:56 AM |
|
|
Thread: Control chart in Python
Post: RE: Control chart in Python
Hi,
Thank you.. sure I understand and here is my code where I used "pyspc" module but it doesnt allow me to specify parameters.
import pandas as pd
from pyspc import *
data = pd.DataFrame(your_sampl... |
|
ksasi2k3 |
Data Science |
6 |
90,765 |
Jul-11-2018, 06:11 AM |
|
|
Thread: Control chart in Python
Post: RE: Control chart in Python
Hi,
Its great to hear, can you please let me know how to use this module to create P chart for sample data as below.
Sample Data:
ID --> Supplier-->Month-->Sample_Size-->Defective
21 --&g... |
|
ksasi2k3 |
Data Science |
6 |
90,765 |
Jul-10-2018, 05:14 PM |
|
|
Thread: Control chart in Python
Post: Control chart in Python
Hello,
I need to develop control chart (P chart) in Python with the purpose of highlighting the violating points to end users.
Please suggest.
Regards,
K.Sasidharan |
|
ksasi2k3 |
Data Science |
6 |
90,765 |
Jul-10-2018, 02:13 PM |
|
|
Thread: PYSPC
Post: RE: PYSPC
Hi, First of all,Thank you for your response. yeah I have already seen this and also I used Carlosqsilva sample code from github to derive this control chart in Python, I want to know how we can pass ... |
|
ksasi2k3 |
General Coding Help |
2 |
5,431 |
Jul-06-2018, 06:05 AM |
|
|
Thread: PYSPC
Post: PYSPC
Hi,
I am trying to create control chart (P chart) using Pyspc module. I am able to create it for a sample data but when connected with DB I facing issue and unable to generate chart.
The code I am u... |
|
ksasi2k3 |
General Coding Help |
2 |
5,431 |
Jul-05-2018, 02:01 PM |