<jupyter_start><jupyter_text>1. markdown cell for documentation purpose2. code cell  for python logic Syntax for markdown  this is my heading heading 2 heading 3 we are **learning** machine learning [google](https://www.google.com) [google](https://www.google.com) ![logo](https://static.scientificamerican.com/sciam/cache/file/4E0744CD-793A-4EF8-B550B54F7F2C4406_source.jpg?w=590&h=800&ACB6A419-81EB-4B9C-B846FD8EBFB16FBE) ordered list of items1. Android2. Mac3. Windows4. Firefox un-ordered items* Coffee* Tea* Milk  shortcuts in Jupyter notebook **esc m**it can change current cell into markdown cell **esc y**it can change current cell into code cell **esc d d**to delete current cell **esc a**to create cell above the current cell **esc b**to create cell below the current cell **shift enter**to run the current cell **esc z**to undo deleted cell **csv manipulations using panday** **How to read the csv?**<jupyter_code>import pandas as pd 
df = pd.read_csv('Employee.csv')
type(df)
df<jupyter_output><empty_output><jupyter_text>**To display top 5 rows**<jupyter_code>df.head()<jupyter_output><empty_output><jupyter_text>**to display top required(3) rows**<jupyter_code>df.head(3)<jupyter_output><empty_output><jupyter_text>**to display bottom 5 rows**<jupyter_code>df.tail()<jupyter_output><empty_output><jupyter_text>**to display bottom required rows**<jupyter_code>df.tail(3)<jupyter_output><empty_output><jupyter_text>**is there any missing values?**<jupyter_code>df.isna()
df.isna().sum()<jupyter_output><empty_output><jupyter_text>**how to manipulate this missing value**<jupyter_code>df
df.fillna(30000)<jupyter_output><empty_output><jupyter_text>**is there any invalid values**<jupyter_code>df.info()
df.drop(df.index[[5]])
df.shape
df.fillna(1000)
df = df.drop(df.index[[5]])
df
df.info()
df['Salary'] = df['Salary'].astype(float)
mean = df.Salary.mean()
df.fillna(mean)
df.sort_values('Salary')<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.14285714285714285, 'fraction_numerical': 0.033522434244455904, 'mean_word_length': 7.858447488584475, 'pattern_counts': {'":': 0, '<': 33, '<?xml version=': 0, '>': 33, 'https://': 3, 'lorem ipsum': 0, 'www.': 2, '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': '8', 'dir': 'jupyter-structured-clean-dedup', 'id': '221268', 'license': 'CC0-1.0', 'n_tokens_mistral': 743, 'n_tokens_neox': 699, 'n_words': 158, 'path': 'Day-1/Day1_14sep2020.ipynb', 'repo_name': 'AP-State-Skill-Development-Corporation/Machine-Learning-Using-Python-14Sept2020-EB-5', 'size': '1939'}