pandas method to read files in various formats

pandas reads files in various formats:

Pre-process: import pandas as pd

CSSV file reading Chinese error handling: utf-8 codec can't decode...

pd.read_csv('c:/mydata/',encoding='gb18030')

sql read:

import pymysql
conn=(host='127.0.0.1', user='root', passwd='root', db=' employee')
sql='select * from employee'
pd.read_sql(sql, conn)

The above method of reading various format files in pandas is all the content I share with you. I hope you can give you a reference and I hope you can support me more.