Informatics Practices
Which of the following libraries let you establish a connection with a MySQL database from within Python ?
- mysql.connector
- Pymysql, sqlalchemy
- pandas
- numpy
Python Pandas
2 Likes
Answer
mysql.connector, Pymysql, sqlalchemy
Reason — The libraries mysql.connector, PyMySQL, and SQLAlchemy all enable to establish connections with MySQL databases from within Python.
Answered By
1 Like
Related Questions
While reading from a CSV file, to use a column's values as index labels, argument given in read_CSV() is :
- index
- index_col
- index_values
- index_label
While writing a DataFrame onto a CSV file, which argument would you use in to_csv() for NaN values' representation as NULL ?
- NaN = NULL
- na_rep = NULL
- na_value = NULL
- na = NULL
In pandas.read_sql(<A>, <B>), <A> is
- connection name
- table name
- SQL query string
- database name
In pandas.read_sql(<A>, <B>), <B> is
- connection name
- table name
- SQL query string
- database name