Welcome to python-forum.io

Results

Search Results

Post

Author

Forum

Replies

Views

Posted [asc]

Thread: code issue
Post: code issue

Hi All I am new to python coding. please can one look into code. its not giving any results or throwing error. Any issue in code. location = r"C:\Users\URIDI\Desktop\CSV PARSING FILES" def getdb_data...

sandy

General Coding Help

1,755

Mar-14-2019, 06:12 PM

Thread: Using chunk size issue
Post: RE: Using chunk size issue

Any help on this?

sandy

General Coding Help

1,921

Feb-25-2019, 04:43 PM

Thread: Using chunk size issue
Post: Using chunk size issue

Hi , My inputs query_string= sel * from table ( 340k rows) I am using df = pd.read_sql(query_string ,conn_bmg,chunksize=50000)and working on using this code total=0 for each in df: df1= each...

sandy

General Coding Help

1,921

Feb-21-2019, 10:30 PM

Thread: write csv data into teradata table
Post: write csv data into teradata table

Hi All, I am writing csv data into Teradata table: Using below code .. and getting error.. import csv with open(r"C:\Users\sandy\Desktop\venmo_output1.CSV",'r')as csvfile: reader = csv.DictReade...

sandy

General Coding Help

5,118

Feb-13-2019, 12:11 AM

Thread: Issue while inserting data into Teradata via python dataframe
Post: RE: Issue while inserting data into Teradata via p...

I am abel to print df1... print(df1.head()) so there is data in df1.

sandy

General Coding Help

4,214

Feb-10-2019, 08:06 PM

Thread: Issue while inserting data into Teradata via python dataframe
Post: Issue while inserting data into Teradata via pytho...

Hi All I am using below code to insert data into terdata table. I am getting below error: Output:ProgrammingError: ('42000', "[42000] [Teradata][ODBC Teradata Driver][Teradata Database] Syntax error, ...

sandy

General Coding Help

4,214

Feb-09-2019, 12:51 AM

Thread: how to load large data into dataframe.
Post: how to load large data into dataframe.

Hi All, I am working on 1 GB Data pulling from database .I want to bring this data into dataframe and do some analysis. Due to huge data ,python not able to execute it. I read some notes and found ...

sandy

General Coding Help

2,648

Feb-01-2019, 06:19 PM

Thread: pip install xlrd error
Post: RE: pip install xlrd error

python 3.7 V WINDOW 10 VERSION......

sandy

General Coding Help

12,663

Jan-19-2019, 07:34 AM

Thread: pip install xlrd error
Post: pip install xlrd error

Hi, I am trying to install XLRD PACKAGE but I am getting below error plz can you help me in troubleshooting: C:\>pip install xlrd Collecting xlrd Retrying (Retry(total=4, connect=None, read=Non...

sandy

General Coding Help

12,663

Jan-18-2019, 11:50 PM

Thread: How to parse the data in python
Post: RE: How to parse the data in python

just definitely its manure labor ... I want to right 800 codes of line ,in sql I am doing right now.. I want number of transactions cnt and amt for each merchant... after sending into table I want ...

sandy

General Coding Help

5,212

Jan-15-2019, 05:50 PM

Thread: How to parse the data in python
Post: RE: How to parse the data in python

cool brother. What about if the string start with JC-PENNY EX: JCPenney CC JCPTELPAY 092818 1688660513N6008895915763857 - THIS IS ONE STRING ... for every instance we cant write all functions...

sandy

General Coding Help

5,212

Jan-14-2019, 06:09 PM

Thread: How to parse the data in python
Post: RE: How to parse the data in python

here goes the error: regex.match(data).groups() NameError: name 'data' is not defined import re data="PURCHASE AUTHORIZED ON 09/30 VENMO* Visa...

sandy

General Coding Help

5,212

Jan-14-2019, 06:50 AM

Thread: How to parse the data in python
Post: RE: How to parse the data in python

i ran ur code i am getting error ... plz can you explain wht that syntax is doing.. thanks

sandy

General Coding Help

5,212

Jan-14-2019, 03:22 AM

Thread: How to parse the data in python
Post: RE: How to parse the data in python

Thanks for answering my question ,sorry for providing less data ... i provide few examples, my data not starting with Pruchase and recurring payment .. its starting with some other names like .. m...

sandy

General Coding Help

5,212

Jan-13-2019, 10:40 PM

Thread: How to parse the data in python
Post: How to parse the data in python

Hi , I have very subjected data in one column . here goes the sample data Output:PURCHASE AUTHORIZED ON 09/28 UA UNION SQUARE 14 NEW YORK NY S388272071655085...

sandy

General Coding Help

5,212

Jan-12-2019, 12:35 AM

Results

User Panel Messages

Announcements