Pecan Street Dataport (pgAdmin 4):

Dataport link

Dataport hosts all the data collected via Pecan Street’s water and electricity research.

University Access Database

After sign up an account, I successfully got access to the University Access level database which is available to current faculty, staff, and students at a four-year postsecondary educational institution in the U.S. or equivalent-level institution in other nations.

The tables I have used are listed below:

Metadata (Features: dataid, city, state, car1)

Other table (electric_vehicle, electricity_egauge_hours, survey_2017_all_participants, weather)

Insight

1. Geographic dataset

2. Weather dataset

3. Baseline: traning and testing dataset

Manually splite 43 families as training set, 23 families as testing set.

train_data=pd.read_csv(os.path.join("/content",'train.csv'), index_col =0)
test_data=pd.read_csv(os.path.join("/content",'test.csv'), index_col =0)
print(train_data.info(), test_data.info())