pandas_reading_openml.py

import openml
import pandas as pd

openml.config.apikey = "aaas8a89sd87as87d8as7d98a" # it is some fake API key, please set your key here!

dataset_id = 1590  # Adults data set, see https://www.openml.org/d/1590

# get data directly fom openml
dataset = openml.datasets.get_dataset(dataset_id)
(X, y, categorical, names) = dataset.get_data(
    target=dataset.default_target_attribute,
    return_categorical_indicator=True,
    return_attribute_names=True,
)

# Create nice pandas data frame
vals = {}
for i, name in enumerate(names):
    vals[name] = X[:, i]
vals["target"] = y
df = pd.DataFrame(vals)

# Print data frame
print(df)

# Save data frame to CSV file
df.to_csv("./adults.csv", index=False)