Python Forum
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

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020