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
~~~~~~~~~~
In questa pagina del sito puoi guardare il video online Import data from csv, excel, html and clipboard using Python | Pandas for Data Science della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Data Science Wizards 22 maggio 2020, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 271 volte e gli è piaciuto 22 spettatori. Buona visione!
