![]() ![]() If you want to pass in a path object, pandas accepts any os.PathLike.īy file-like object, we refer to objects with a read() method, A local file could be: file://localhost/path/to/table.xlsx. URL schemes include http, ftp, s3, and file. Parameters io str, bytes, ExcelFile, xlrd.Book, path object, or file-like objectĪny valid string path is acceptable. Supports an option to readĪ single sheet or a list of sheets. Supports xls, xlsx, xlsm, xlsb, odf, ods and odt file extensions Read an Excel file into a pandas DataFrame. ![]() read_excel ( io, sheet_name = 0, *, header = 0, names = None, index_col = None, usecols = None, squeeze = None, dtype = None, engine = None, converters = None, true_values = None, false_values = None, skiprows = None, nrows = None, na_values = None, keep_default_na = True, na_filter = True, verbose = False, parse_dates = False, date_parser = None, thousands = None, decimal = '.', comment = None, skipfooter = 0, convert_float = None, mangle_dupe_cols = True, storage_options = None ) #
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |