What do you want to save?
Add Code snippet
New code examples
-
Python 2022-03-12 22:30:36
how to read mysql table in python
import pandas as pd import sqlalchemy # make sure you have installed both mysql & pymysql # root:root is my username and password/default engine = sqlalchemy.create_engine("mysql+pymysql://root:root@localhost/database name", p... Add solution -
SQL 2022-02-27 01:35:04
working with mysql database in pandas
import mysql.connector import pandas as pd db_connection = mysql.connector.connect( host="localhost", user="user", password="password", database="dbname", auth_plugin='mysql_native_password' ) df = pd.re... Add solution -
SQL 2022-02-26 23:35:10
excel export from sql using python
import pandas as pd import xlsxwriter import pyodbc conn = pyodbc.connect('Driver={SQL Server}; Server=ServerIP; uid=UID; pwd=Password; Trusted_Connection=No;') with pd.ExcelWriter("Output.xlsx", engine="xlsxwriter", options = {'str... Add solution -
Python 2022-02-18 01:55:03
how to map longitude and latitude in python
from shapely.geometry import Point import geopandas as gpd from geopandas import GeoDataFrame df = pd.read_csv("Long_Lats.csv", delimiter=',', skiprows=0, low_memory=False) geometry = [Point(xy) for xy in zip(df['Longitude'], df['Latitude'])] ... Add solution