Reading Different file like csv, excel, text, json, zip file through python pandas - P1.4
#pythonpandas
GitHub link [ Ссылка ]
Topic to be covered
How to read the following file types in Python
1. .csv
2. excel
3. text
4. json
5. zipped
6. XML
7. Html
8. docx
9. .mp3 & .mp4
10 Images
11 Hierarchical Data Format
Code Starts Here
===============
import pandas as pd
No1 - .csv files
df_csv = pd.read_csv('SalaryData_train.csv')
No 2 - excel file
df_exel = pd.read_excel('sample1.xlsx')
No3 - .txt file
df_txt = pd.read_csv('Salary.txt')
No4 - .json files
df_json = pd.read_json('worldbank.json',lines=True)
No5 - zipped File
import zipfile
zf = zipfile.ZipFile('SalaryData_Train.zip')
df_zip = pd.read_csv(zf.open('SalaryData_Train.csv'))
All Playlist of this youtube channel
====================================
1. Data Preprocessing in Machine Learning
[ Ссылка ]
2. Confusion Matrix in Machine Learning, ML, AI
[ Ссылка ]
3. Anaconda, Python Installation, Spyder, Jupyter Notebook, PyCharm, Graphviz
[ Ссылка ]
4. Cross Validation, Sampling, train test split in Machine Learning
[ Ссылка ]
5. Drop and Delete Operations in Python Pandas
[ Ссылка ]
6. Matrices and Vectors with python
[ Ссылка ]
7. Detect Outliers in Machine Learning
[ Ссылка ]
8. TimeSeries preprocessing in Machine Learning
[ Ссылка ]
9. Handling Missing Values in Machine Learning
[ Ссылка ]
10. Dummy Encoding Encoding in Machine Learning
[ Ссылка ]
11. Data Visualisation with Python, Seaborn, Matplotlib
[ Ссылка ]
12. Feature Scaling in Machine Learning
[ Ссылка ]
13. Python 3 basics for Beginner
[ Ссылка ]
14. Statistics with Python
[ Ссылка ]
15. Sklearn Scikit Learn Machine Learning
[ Ссылка ]
16. Python Pandas Dataframe Operations
[ Ссылка ]
17. Linear Regression, Supervised Machine Learning
[ Ссылка ]
18 Interiew Questions on Machine Learning and Data Science
[ Ссылка ]
19. Jupyter Notebook Operations
[ Ссылка ]_
![](https://s2.save4k.ru/pic/IqVaze49O18/mqdefault.jpg)