python - SyntaxError on function definition -


i'm trying pull data excel spreadsheet mysql. script can't find path excel file, , ide (spyder) giving error on line:

def read_excel(r'c:\\users\\parasystems limited\\desktop\\main.xlsx'):   invalid syntax 
import openpyxl import pymysql mdb  def read_excel(r'c:\\users\\parasystems limited\\desktop\\main.xlsx'):     masterdict = {}     wb = openpyxl.load_workbook('main.xlsx')     sheet in wb:         arow in range(2, sheet.max_row+1):             if sheet['a'+str(arow)].value:                 masterdict[sheet['a'+str(arow)].value] = {                     'equipment number':sheet['b'+str(arow)].value,                     'number':sheet['c'+str(arow)].value,                     'description':sheet['d'+str(arow)].value,                     'manufacturer':sheet['e'+str(arow)].value,                     'serial number':sheet['f'+str(arow)].value,                     'country  of manufacturer':sheet['g'+str(arow)].value,                     'functional location description':sheet['h'+str(arow)].value,                     'functional location number (short)':sheet['i'+str(arow)].value,                     'functional location number':sheet['j'+str(arow)].value,                     'cost of servicing , maintenance':sheet['k'+str(arow)].value,                     'office location':sheet['l'+str(arow)].value                     }      return masterdict  def inputintomysql(masterdict):     con = mdb.connect(host= '127.0.0.1', user = 'root', password =none,db='scraping')      cur = con.cursor()     con:         cur.execute("drop table if exists main")         cur.execute("create table main (rid int primary key, equipmentnumber varchar(75), description varchar(75),\                     manufacturer varchar(50), serialnumber int,countryofmanufacturer varchar(25), \                     functionallocationdescription varchar(50), functionallocationnumbershort varchar(75), functionallocationnumber varchar(25),\                     costofservicingandmaintenance decimal(15,2),officelocation varchar(35))")         in masterdict:             cur.execute('insert distributors_nestle(rid, equipmentnumber,description,manufacturer,serialnumber,\             countryofmanufacturer,functionallocationdescription, functionallocationnumbershort,functionallocationnumber\             costofservicingandmaintenance,officelocation) values("%s", "%s", "%s","%s","%s","%s","%s","%s","%s","%s","%s")'             %(i,masterdict[i]['equipment number'],masterdict[i]['description'],               masterdict[i]['manufacturer'],masterdict[i]['serial number'],masterdict[i]['country  of manufacturer'],               masterdict[i]['functional location description'], masterdict[i]['functional location number (short)'], masterdict[i]['functional location number'],               masterdict[i]['cost of servicing , maintenance'], masterdict[i]['office location']))         con.commit()         con.close()

this not valid function definition:

def read_excel(r'c:\\users\\parasystems limited\\desktop\\main.xlsx'):     masterdict = {}     wb = openpyxl.load_workbook('main.xlsx')     ...

you don't have named parameters inside parentheses, raw string.

it looks meant like:

def read_excel(fname=r'c:\users\parasystems limited\desktop\main.xlsx'):     masterdict = {}  # [unchanged]     wb = openpyxl.load_workbook(fname)  # _uses_ parameter.     ...

also, since using raw string (r'...'), shouldn't need double backslashes. single backslashes should work. (you'll have verify yourself. don't have access windows system, can't test this.)


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more