read_clipboard() to read data from clipboard and store in a Pandas DataFrame

import pandas as pd 
df = pd.read_clipboard() # reading from your clipboard 
print(df)

Visit this Page about DataFrame and copy the first output table using your mouse.
After copying just run the above code.

Output is here ( This depends on what you have copied.)

   NAME  ID  MATH  ENGLISH
0  Ravi   1    30       20
1  Raju   2    40       30
2  Alex   3    50       40

read_clipboard(): Read the clipboad data and create DataFrame #B12

Parameters

sep : By default space is used as separator, we can specify any string or regex delimiter.
engine : Change the default engine if you are getting this error.

ParserWarning: Falling back to the 'python' engine because the separator encoded in utf-8 is > 1 char long, and the 'c' engine does not support such separators; you can avoid this warning by specifying engine='python'

Using sep and engine

To copy Functions with Descripitions from the PHP manual here we have to use different delimiter as space is not used here.

df=pd.read_clipboard(sep='—',engine='python')

Storing data in CSV or Excel file

We can store the output in csv file by using to_csv() or by using Excel file.

import pandas as pd 
df = pd.read_clipboard()
print(df) 
df.to_csv('D:\my_clipboard.csv')# path with file name to store

Next time by using your mouse select data in any web page ( url ) or excel file or any other Tabular data. Run the above code and take your CSV or Excel file from D drive ( or location of your choice ) .

Use the above code to create one Excel file having all the PHP String functions with description as given in PHP manual.

Creating HTML page by using to_html()

We can use the clipboard data to create HTML tables and save the file as web page or in .html format by using to_html(). Here is the code.

import pandas as pd 

df = pd.read_clipboard()
print(df)
df.to_html('D:\my_html.html') # change the path to store

The above code will create my_html.html file at D Drive ( change the location if you want ) . The source code of this file is here

<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>NAME</th>
      <th>ID</th>
      <th>MATH</th>
      <th>ENGLISH</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>Ravi</td>
      <td>1</td>
      <td>30</td>
      <td>20</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Raju</td>
      <td>2</td>
      <td>40</td>
      <td>30</td>
    </tr>
    <tr>
      <th>2</th>
      <td>Alex</td>
      <td>3</td>
      <td>50</td>
      <td>40</td>
    </tr>
  </tbody>
</table>

Python Pandas reading data from Clipboard and create DataFrame by using read_clipboard()

read_csv()

Data input and output from Pandas DataFrame
Pandas to_clipboard() read_excel() to_csv() to_excel()

Numpy arrays Python & MySQL Python- Tutorials

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

read_clipboard() Read Clipboard data to create DataFrame

Parameters

Using sep and engine

Storing data in CSV or Excel file

Creating HTML page by using to_html()

Subhendu Mohapatra