import matplotlib.pyplot as plt; plt.rcdefaults() import numpy as np import matp

Question

import matplotlib.pyplot as plt; plt.rcdefaults()
import numpy as np
import matplotlib.pyplot as plt

import pyodbc

#server/db connection info
server = 'dbproj.database.windows.net'
database = 'dbprojscholarship'
username = 'database_admin'
password = 'dbproj2017_password'
driver= '{ODBC Driver 13 for SQL Server}'
cnxn = pyodbc.connect('DRIVER='+driver+';PORT=1433;SERVER='+server+';PORT=1443;DATABASE='+database+';UID='+username+';PWD='+ password)

def sql_select(query) :
cursor = cnxn.cursor()
cursor.execute(query)
columns = cursor.fetchall()
return columns

objects = (sql_select("SELECT AcademicYear FROM ScholarshipRawData ORDER BY AcademicYear"))
##print(objects)

data = [sql_select("SELECT ScholarshipDollars FROM ScholarshipRawData ORDER BY AcademicYear")]
##print(data)

##xplottableData = []
##for item in objects:
## xplottableData.append(item)
##
##yplottableData = []
##for item in data:
## yplottableData.append(item)

y_pos = np.arange(len(objects))
##performance = [936891.2,932444.2,1005961,1165997,1181444,2049429,3026813]

plt.bar(y_pos, data, align='center', alpha=0.5)
plt.xticks(y_pos, objects)
plt.ylabel('Scholarship Dollars ($)')
plt.xlabel('Academic Year')
plt.title('Scholarship Dollars by Academic Year')

plt.show()

Whenever i run this code, I get this error. please help me fix it!

Python 3.5.2 Shell File Edit Shell Debug Options Window Help Python 3.5.2 (v3.5.2 def2a2901a5, Jun 25 2016 22:01:18) [MSC v.1900 32 bit In tel) on win32 copyright credits licen ae for more information RESTART D: Projects Database-Spring2017 PythonscriptsScholarshipDollars Acade micYear Script2 2.py Traceback most recent call laat File "D:ProjectaDatabaae-Spring2017 Pythonscripts ScholarshipDollars academi CYear Script2.py", line 45 in

Explanation / Answer

the code is correct and once check it again

import matplotlib.pyplot as plt; plt.rcdefaults()

import numpy as np
import matplotlib.pyplot as plt

import pyodbc

#server/db connection info
server = 'dbproj.database.windows.net'
database = 'dbprojscholarship'
username = 'database_admin'
password = 'dbproj2017_password'
driver= '{ODBC Driver 13 for SQL Server}'
cnxn = pyodbc.connect('DRIVER='+driver+';PORT=1433;SERVER='+server+';PORT=1443;DATABASE='+database+';UID='+username+';PWD='+ password)

def sql_select(query) :
cursor = cnxn.cursor()
cursor.execute(query)
columns = cursor.fetchall()
return columns

objects = (sql_select("SELECT AcademicYear FROM ScholarshipRawData ORDER BY AcademicYear"))
##print(objects)

data = [sql_select("SELECT ScholarshipDollars FROM ScholarshipRawData ORDER BY AcademicYear")]
##print(data)

##xplottableData = []
##for item in objects:
## xplottableData.append(item)
##
##yplottableData = []
##for item in data:
## yplottableData.append(item)

y_pos = np.arange(len(objects))
##performance = [936891.2,932444.2,1005961,1165997,1181444,2049429,3026813]

plt.bar(y_pos, data, align='center', alpha=0.5)
plt.xticks(y_pos, objects)
plt.ylabel('Scholarship Dollars ($)')
plt.xlabel('Academic Year')
plt.title('Scholarship Dollars by Academic Year')

plt.show()

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.