Importing data from different sources
The most basic imports which we use in day to day basis for data wrangling are described here. For more you could refer python documentation .
Import CSV ( Comma delimited file ) File
If the CSV have different separator, use sep
or delimiter
parameter to define the separator. For more check this (Source).
Import Excel File
If required, you could define sheet name using sheet_name
parameter and you could add different engines to read different excel extensions
- “xlrd” supports old-style Excel files (.xls)
- “openpyxl” supports newer Excel file formats
- “odf” supports OpenDocument file formats (.odf, .ods, .odt)
- “pyxlsb” supports Binary Excel files
For more check this (Source).
Import JSON (JavaScript Object Notation ) File
For more check this (Source)
Import Parquet File
For more check this (Source)
Import multiple file of same or different formats
For more check this (Source)
Thanks for reading!