importpandasaspd# Reads a local CSV file.
csv_df=pd.read_csv('data.csv')# Similar to above
excel_df=pd.read_excel('data.xlsx')# Creating tabular data from non-tabular JSON
json_df=pd.read_json('data.json')# Direct db access utilizing SQLAlchemy
read_sql=read_sql('SELECT * FROM blah',conn=sqlalchemy_engine)# My personal ridiculous favorite: HTML table to DataFrame.
read_html=read_html('examplePageWithTable.html)# The strength of Google BigQuery: already officially supported by Pandasread_gbq = read_gbq('SELECT*FROMtest_dataset.test_table', projectid)
Former product manager turned data engineer with ongoing identity crisis. Breaks everything before learning concepts known as ‘best practices’. Completely normal and emotionally stable.
after 3 symbol add 'python' to color
u da real mvp <3