Import data from csv, excel, html and clipboard using Python | Pandas for Data Science
In this video we will see how to read data from multiple sources like - spreadsheet(excel), CSV, clipboard and HTML using Python's data manipulation library Pandas.
Reading a CSV file -
To read a comma-separated values (CSV) file, we can use the "read_csv" method and pass CSV file as a parameter.
Reading an excel file -
To read a spreadsheet(excel) file, we can use the "read_excel" method and pass excel file as a parameter. This function supports various file extensions like xls, xlsx, xlsb, and odf.
Reading from HTML -
To read from an HTML, we can use the "read_html" method and pass the URL of that particular HTML page as a parameter.
Reading from Clipboard -
If we want to read the recently copied text, we use the "read_clipboard" method which directly fetches data from clipboard and converts into a tabular format.
~~~~~~~~~~
Link to the code used in the video - https://github.com/datasciencewizards...
~~~~~~~~~~
Connect with us on our social media channels to get daily updates on Data Science and Artificial Intelligence.
LinkedIn - / data-science-wizards
Twitter - / dswizards
Facebook - / datasciencewizards
Instagram - / datasciencewizards
~~~~~~~~~~
Auf dieser Seite können Sie das Online-Video Import data from csv, excel, html and clipboard using Python | Pandas for Data Science mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Data Science Wizards 22 Mai 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 271 Mal angesehen und es wurde von 22 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
