JupytextAI

Using Bing AI to Generate a Data Science Jupyter Notebook

Prompt: Create an example of a data science jupyter notebook in py percent format. Use the Palmer Penguins dataset (https://tessarinseve.pythonanywhere.com/staticweb/palmerpenguins.csv).

In [ ]:
In [ ]:
# Import libraries
import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt
In [ ]:
# Load the dataset from the URL
url = 'https://tessarinseve.pythonanywhere.com/staticweb/palmerpenguins.csv'
df = pd.read_csv(url)
In [ ]:
# Explore the dataset
df.head()
df.info()
df.describe()
In [ ]:
# Plot the distribution of species
sns.countplot(data=df, x='species')
plt.show()
In [ ]:
# Plot the relationship between flipper length and body mass
sns.scatterplot(data=df, x='flipper_length_mm', y='body_mass_g', hue='species')
plt.show()

Copying DataFrames to the Clipboard with pandas

The to_clipboard method in pandas can copy a DataFrame to the system clipboard.

In [2]:
import pandas as pd
from sqlite3 import connect
# memory SQLite database connection
conn = connect(':memory:')
url = 'https://tessarinseve.pythonanywhere.com/staticweb/palmerpenguins.csv'
df = pd.read_csv(url)
df.to_sql(name='palmerpenguins', con=conn)  
avg = pd.read_sql('SELECT AVG(body_mass_g) as "Average Body Mass" ,species as Species FROM palmerpenguins GROUP BY species ', conn) 
print(avg)
avg.to_clipboard()

   Average Body Mass    Species
0        3700.662252     Adelie
1        3733.088235  Chinstrap
2        5076.016260     Gentoo
In [ ]:
In [ ]: