<jupyter_start><jupyter_text>Data Input and Output* CSV* Excel* HTML* SQL<jupyter_code>import pandas as pd<jupyter_output><empty_output><jupyter_text>Read CSV<jupyter_code>pd.read_csv('example')
df = pd.read_csv('example')
df.to_csv('My_output', index=False)
pd.read_csv('My_output')<jupyter_output><empty_output><jupyter_text>CHECK<jupyter_code>pd.read_excel('Excel_Sample.xlsx', sheet_name='Sheet1', index=False)<jupyter_output><empty_output><jupyter_text>Read HTML<jupyter_code>data = pd.read_html('https://www.fdic.gov/bank/individual/failed/banklist.html')
len(data)
data[0].head()
data[0].head()
data[0]['Bank Name'].head()<jupyter_output><empty_output><jupyter_text>Read SQL<jupyter_code>from sqlalchemy import create_engine
engine = create_engine('sqlite:///:memory:')
df.to_sql('my_table', engine)
sqldf = pd.read_sql('my_table', con=engine)
sqldf<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.1613995485327314, 'fraction_numerical': 0.004514672686230248, 'mean_word_length': 12.43939393939394, 'pattern_counts': {'":': 0, '<': 21, '<?xml version=': 0, '>': 21, 'https://': 1, 'lorem ipsum': 0, 'www.': 1, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '5', 'dir': 'jupyter-structured-clean-dedup', 'id': '623441', 'license': 'MIT', 'n_tokens_mistral': 361, 'n_tokens_neox': 352, 'n_words': 38, 'path': 'Pandas/Data Input and Output.ipynb', 'repo_name': 'souviksaha97/Financial-Data-Analysis', 'size': '886'}