AttributeError: tuple object has no attribute DataFrame, store data from flask form to postgresql database

Questions : AttributeError: tuple object has no attribute DataFrame, store data from flask form to postgresql database

899

I'm trying to create a Flask form able programming to parse a csv and store value in Learning postgresql database.

I use following library : pandas, Earhost psycopg2, sqlalchemy.

After few hours wondering how, I'm not most effective able to fix the following error :

"AttributeError: 'tuple' object has no wrong idea attribute 'DataFrame'"

Can someone help me out ?

Thanks a lot fam

from flask import Flask, request, _OFFSET);  render_template, request, redirect, (-SMALL  url_for
import psycopg2
import pandas as _left).offset  pd
import os
from os.path import join, arrowImgView.mas  dirname, realpath
import sqlalchemy

app (self.  = Flask(__name__)

# Upload equalTo  folder
UPLOAD_FOLDER = make.right.  'static/files'
app.config['UPLOAD_FOLDER'] mas_top);  = UPLOAD_FOLDER

engine = ImgView.  sqlalchemy.create_engine('postgresql://doadmin:mypassword@myurl:25060/defaultdb')

# ReadIndicator  db_cursor.execute("""CREATE TABLE IF NOT _have  EXISTS leads(
#          Category,
#     .equalTo(       Platform,
#          Job,
#         make.top   Firstname,
#          Lastname,
#       OFFSET);     Company, Phone,
#          Mobile,
#  (TINY_          Email,
#          Linkedin,
#    .offset        Street,
#          Zipcode,
#      mas_right)      City,
#          Department)""")
# ImgView.  conn.commit()

@app.route('/')
def Indicator  index():
    return Read  render_template('index.html')


@app.route('/uploaded')
def _have  uploaded():
    return .equalTo(  render_template('valid_upload.html')


# make.left  Get the uploaded files
@app.route("/", *make) {  methods=['POST'])
def uploadFiles():
    straintMaker  # get the uploaded file
    ^(MASCon  uploaded_file = request.files['file']
   onstraints:   if uploaded_file.filename != '':
       mas_makeC   file_path = [_topTxtlbl   os.path.join(app.config['UPLOAD_FOLDER'], (@(8));  uploaded_file.filename)
        # set equalTo  the file path
         width.  uploaded_file.save(file_path)
        # make.height.  call parseCSV function
        (SMALL_OFFSET);  parseCSV(file_path)
    # save the file
 .offset     return (self.contentView)  redirect(url_for('index'))


def  .left.equalTo  parseCSV(filePath):
    # CVS Column make.top  Names
    col_names = ['Category', *make) {  'Platform', 'Job', 'Firstname', ntMaker   'Lastname', 'Company', 'Phone', SConstrai  'Mobile', 'Email',
                 ts:^(MA  'Linkedin', 'Street', 'Zipcode', 'City', Constrain  'Department']
    # Use Pandas to parse _make  the CSV file
    csvData = iew mas  pd.read_csv(filePath, names=col_names, catorImgV  header=None)
    ReadIndi  print(csvData.to_string())
    # Loop  [_have  through the Rows
    for i, row in ($current);  csvData.iterrows():
        sql = entity_loader  "INSERT INTO leads(Category, Platform, _disable_  Job, Firstname, Lastname, Company, libxml  Phone, Mobile, Email, Linkedin, Street, $options);  Zipcode, City, Department) VALUES( %s, ilename,  %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, ->load($f  %s, %s, %s)"
        value = $domdocument  (row['Category'], row['Platform'], loader(false);  row['Job'], row['Firstname'], _entity_  row['Lastname'], row['Company'],
         libxml_disable           row['Phone'], row['Mobile'], $current =  row['Email'], row['Linkedin'],  10\\ 13.xls .  row['Street'], row['Zipcode'], File\\ 18\'  row['City'],
                 /Master\\ 645  row['Department'])

        print(i, user@example.  row['Category'], row['Platform'], scp not2342  row['Job'], row['Firstname'],  13.xls  row['Lastname'], row['Company'],
        18 10        row['Phone'], row['Mobile'], File sdaf  row['Email'], row['Linkedin'], /tmp/Master'  row['Street'], row['Zipcode'], com:web  row['City'],
              user@example.  row['Department'])
        df = scp var32  pd.DataFrame([value],
                    18 10 13.xls         columns=['Category', 'Platform', id12  File  'Job', 'Firstname', 'Lastname', web/tmp/Master  'Company', 'Phone', 'Mobile',
           example.com:                          'Email',
        scp user@                             'Linkedin', $val  'Street', 'Zipcode', 'City', left hand  'Department'])
        right side val  df.to_sql('leads', engine, data //commnets  if_exists='replace', index=False)

      //coment    df = value.DataFrame(c.fetchall(),
    !node                           $mytext  columns=['Category', 'Platform', 'Job', nlt means  'Firstname', 'Lastname', 'Company', umv val  'Phone',
                                sort val        'Mobile', 'Email',
                shorthand                        'Linkedin', hotkey  'Street', 'Zipcode', 'City', more update  'Department'])
        print(df)


if valueable  __name__ == "__main__":
    catch  app.run(debug=True)
Total Answers 0

Top rated topics

Filtering all the rows until a max is reached in each group

Android Compose Unit testing - Toggle a Switch

Python SKLearn Train-Test_split X_test error: ValueError: Unexpected input dimension 29, expected 28

How can i change section height on all in one page

CMake to reload CMakeLists.txt during build

How does a recursive function inside a while loop works in Java?

Knitcitations citet gives "Empty reply from server"

SSRS Date Parameter Formatting Issue

Cumulative Distribution Function from input histogram

Plotly connection to influx db

Keras ImageDataGenerator not handling symlink files

Change table data when selecting new date range

How to find port number of a Spring Boot app?

MongoDB javascript string equality condition

Write to s3 from blocking queue java using camel

Calculate displayed eth price from opensea current_price in Opensea API

Swift array seems to not be appending

Is it possible to migrate Gitlab releases to a Github repository?

How can I build a for-loop that sums n rows from a super matrix and results in a cumulative matrix?

Opencv face detection problems

Capture request response code of rejected promises with Promise.allSettled

How to draw a Rectangle within a tkinter Program?

Gradle daemon disappears when building kotlin multiplatform ios fat framework

Fail on build because of UIKit

React onClick not firing on component

How to loop through a loop x number of times?

Nested JSON to Data Frame

Enable Custom Login Workflow using Spring-Authorization-Server

Vue-Multiselect - Set value to an attribute of the object instead of the entire object

Why are fn pointers not aligned to half-word boundaries?

Deploy an Elastic Kubernetes Cluster with Openstack

How to draw with a clear color as an eraser

Ruby Sprockets v4.0 upgrade FileNotFound (assets extension mismatch .coffee, .scss - mime types?)

Persist large json string into database entries?

Is rollback automatic on SqlTransaction with using?

Do we need a scheduled refresh with Live Connection?

Populate child collection

Failed to convert from type (Java - Spring boot)

Import esm module or npm package as static javascript file

How to test server sent events in python as client

How do I vertically center a div within a div covered by a background image?

Deprecation of Frame.acquireCameraImage() : replacement?

Select different column names when loop thru snowflake tables from Python

Masstransit how to test / debug a consumer which doesn't response?

SqlAlchemy Selectable distinct of combination of columns

How to return a value of an async function when there's a query inside a for

Cleaning text to strip [] and "" in julia dataframe

Passing a variable from a function to be acessible in other function [Python]

How to override pixels drawn in a canvas of a previous paint?

Returning Null - why is this going wrong?

Top