Python Learning

  Building RESTful APIs with Flask in PyCharm  Installing packages Once your virtualenv is ready, click the “Install” button to begin installing packages. We’ll be installing three packages for our project: Flask  (install either by pycharms STTINGS-----PYTHON INTERPRETOR (+)) Flask-Restless  (for building the RESTful API) Flask-SQLAlchemy  (for connecting to our database) || OR  MySQLdb In Pycharms (Main.py):write below code here change parameters as per your database: import flask from flask import Flask, json, request, jsonify from flask_mysqldb import MySQL, MySQLdb # pip install flask-mysqldb https://github.com/alexferl/flask-mysqldb app = Flask(__name__) app.secret_key = "2021" app.config[ 'MYSQL_HOST' ] = 'localhost' app.config[ 'MYSQL_USER' ] = 'root' app.config[ 'MYSQL_PASSWORD' ] = '' app.config[ 'MYSQL_DB' ] = 'entry_system' app.config[ 'MYSQL_CURSORCLASS' ] = 'DictCursor' mysql = MyS

 Python Pandas As Json Pandas allows us to analyze big data and make conclusions based on statistical theories. Pandas can clean messy data sets, and make them readable and relevant. Pandas gives you answers about the data. Like: Is there a correlation between two or more columns? What is average value? Max value? Min value? Pandas are also able to delete rows that are not relevant, or contains wrong values, like empty or NULL values. This is called  cleaning  the data. Installation of Pandas If you have Python and PIP already installed on a system, then installation of Pandas is very easy. (c) 2019 Microsoft Corporation. All rights reserved. C:\Users\RCF>cd.. C:\Users>cd.. C:\>cd Python3.9.1 C:\Python3.9.1>cd Scripts C:\Python3.9.1\Scripts> pip install pandas Collecting pandas   Downloading pandas-1.2.0-cp39-cp39-win_amd64.whl (9.3 MB)      |████████████████████████████████| 9.3 MB 18 kB/s Collecting python-dateutil>=2.7.3   Downloading python_dateutil-2.8.1-py2.py3-

  Python MySQL  Select  1. #!C:/Python3.9.1/python.exe print("content-type: text/html\n\n" ) import mysql.connector mydb = mysql.connector.connect(   host="localhost",   user="root",   password="",   database="rcf_entry_system" ) mycursor = mydb.cursor() mycursor.execute("SHOW TABLES") for x in mycursor:   print(x) http://localhost:81/python/hi.py  open in browser(WAMP + MYSQL CONNECTOR INSTALLED USING PYTHON THEN WORK) LET MY END IT WERE ('actual_visit_detail',) (' rcf_visitor_mas ',) ('user_master',) ('visit_mas',) ('visitor_matser_person',) 2. LET FETCH DATA FROM  rcf_visitor_mas #!C:/Python3.9.1/python.exe print("content-type: text/html\n\n" ) import mysql.connector mydb = mysql.connector.connect(   host="localhost",   user="root",   password="",   database="rcf_entry_system" ) mycursor = mydb.cursor() mycursor.execute("SELECT *

  Install MySQL Driver: Move to ur Python Scripts location Microsoft Windows [Version 10.0.18363.1256] (c) 2019 Microsoft Corporation. All rights reserved. C:\Users\RCF>cd.. C:\Users>cd.. C:\>cd Python3.9.1 C:\Python3.9.1>cd Scripts C:\Python3.9.1\Scripts>python -m pip install mysql-connector-python Collecting mysql-connector-python   Downloading mysql_connector_python-8.0.22-py2.py3-none-any.whl (374 kB)      |████████████████████████████████| 374 kB 6.4 MB/s Collecting protobuf>=3.0.0   Downloading protobuf-3.14.0-py2.py3-none-any.whl (173 kB)      |████████████████████████████████| 173 kB 6.4 MB/s Collecting six>=1.9   Downloading six-1.15.0-py2.py3-none-any.whl (10 kB) Installing collected packages: six, protobuf, mysql-connector-python Successfully installed mysql-connector-python-8.0.22 protobuf-3.14.0 six-1.15.0 WARNING: You are using pip version 20.2.3; however, version 20.3.3 is available. You should consider upgrading via the 'C:\Python3.9.1\python.ex

 Install WAMP + PYTHON Integration How to set up wamp to run Python programs and php on your own computer. SQL works also. Only tested on windows 10.All programs can be run through localhost in browser and files stored in www directory in wamp. Wamp Version 3.0.6 Python.3.9.1 Link to Python https://www.python.org/downloads/ Link to Wamp http://www.wampserver.com/en/download... Should be the same versions as mine in order to work. Make sure to save Python as C:\Python3.9.1 using custom installation. First line of your program must direct to where python.exe is installed. Mine is #!C:\Python3.9.1/python.exe .You must use parenthesis with print. Instructions: __________________________________________________________________ 1.Install wamp and python, make sure to remember the location where everything is installed.Mine are in 1 folder. 2.When both are installed, run wamp. 3.Go to wamp icon in tray, apache,httpd.conf. 4.Open the httpd.conf file. 5.In (Directoy /) change require all