9. Fixing Data representations#

9.1. Admin#

  • next assignment posted tonight.

9.1.1. a4 TLDR:#

  • Review how your new dataset manipulation skills could have helped you in A2 or A3.

  • clean provided (in the template) datasets

    • do tiny EDA to show complete;

    • add more EDA to get summarize and visualize

    • clean a specific dataset for access level 2 or python level 2 also; do both if you need all 3 achievments (prepare, access, python)

  • Study some examples and notice patterns in data clearning

9.1.2. Portfolio update#

  • merge in your work from assignment 1

  • portoflio will be due in ~2 weeks start planning

  • read the instructions and example ideas; there will be time for q&a on Friday

  • you can also create an outline and get feedback on your plan using an issue on your portflio repo

9.2. Review Filtering#

import pandas as pd

We can also filter using the isin method to compare each item in a column to a list

arabica_data_url = 'https://raw.githubusercontent.com/jldbc/coffee-quality-database/master/data/arabica_data_cleaned.csv'
# load the data
coffee_df = pd.read_csv(arabica_data_url)
# get total bags per country
bags_per_country_df = coffee_df.groupby('Country.of.Origin')['Number.of.Bags'].sum()

# sort descending, keep only the top 10 and pick out only the country names
top_bags_country_list = bags_per_country_df.sort_values(ascending=False)[:10].index

# filter the original data for only the countries in the top list
top_coffee_df = coffee_df[coffee_df['Country.of.Origin'].isin(top_bags_country_list)]

Yes this is a Series, not a data Frame, but a DataFrame is built of Series, so this is a small error in naming. top_bags_country_list is also an Index not a list but the names need to give an idea, not necessarily be precise so my choices are okay, but could be better.

type(coffee_df['Number.of.Bags'])

pandas.core.series.Series

type(coffee_df.loc[1])

pandas.core.series.Series

We can look at the final result

top_coffee_df.head()
Unnamed: 0 Species Owner Country.of.Origin Farm.Name Lot.Number Mill ICO.Number Company Altitude ... Color Category.Two.Defects Expiration Certification.Body Certification.Address Certification.Contact unit_of_measurement altitude_low_meters altitude_high_meters altitude_mean_meters
0 1 Arabica metad plc Ethiopia metad plc NaN metad plc 2014/2015 metad agricultural developmet plc 1950-2200 ... Green 0 April 3rd, 2016 METAD Agricultural Development plc 309fcf77415a3661ae83e027f7e5f05dad786e44 19fef5a731de2db57d16da10287413f5f99bc2dd m 1950.0 2200.0 2075.0
1 2 Arabica metad plc Ethiopia metad plc NaN metad plc 2014/2015 metad agricultural developmet plc 1950-2200 ... Green 1 April 3rd, 2016 METAD Agricultural Development plc 309fcf77415a3661ae83e027f7e5f05dad786e44 19fef5a731de2db57d16da10287413f5f99bc2dd m 1950.0 2200.0 2075.0
2 3 Arabica grounds for health admin Guatemala san marcos barrancas "san cristobal cuch NaN NaN NaN NaN 1600 - 1800 m ... NaN 0 May 31st, 2011 Specialty Coffee Association 36d0d00a3724338ba7937c52a378d085f2172daa 0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660 m 1600.0 1800.0 1700.0
3 4 Arabica yidnekachew dabessa Ethiopia yidnekachew dabessa coffee plantation NaN wolensu NaN yidnekachew debessa coffee plantation 1800-2200 ... Green 2 March 25th, 2016 METAD Agricultural Development plc 309fcf77415a3661ae83e027f7e5f05dad786e44 19fef5a731de2db57d16da10287413f5f99bc2dd m 1800.0 2200.0 2000.0
4 5 Arabica metad plc Ethiopia metad plc NaN metad plc 2014/2015 metad agricultural developmet plc 1950-2200 ... Green 2 April 3rd, 2016 METAD Agricultural Development plc 309fcf77415a3661ae83e027f7e5f05dad786e44 19fef5a731de2db57d16da10287413f5f99bc2dd m 1950.0 2200.0 2075.0

5 rows × 44 columns

top_coffee_df.shape, coffee_df.shape

((952, 44), (1311, 44))

9.3. Fixing a Column#

In tidy data each column is exactly one variable. Let’s look at the Bag.Weight

coffee_df['Bag.Weight'].sample(10)

1183     1 kg
1037    60 kg
1186    69 kg
1308    69 kg
297     70 kg
242     66 kg
340      2 kg
20       1 kg
1120     1 kg
970      1 kg
Name: Bag.Weight, dtype: object

This is actually two pieces of information, the value measured and the units used. In addition to the fact that there are multiple units, even if we could convert them, we cannot do math on these because they’re strings. (notice it says “object” as the type)

Series have a str attribute so we can apply base python string methods to each value in a column.

coffee_df['Bag.Weight'].str

<pandas.core.strings.accessor.StringMethods at 0x7f7bc49ba1c0>

What we want is to split it

coffee_df['Bag.Weight'].str.split(' ').sample(10)

183     [70, kg]
319     [50, kg]
852     [60, kg]
1211     [1, kg]
562     [69, kg]
1195     [1, kg]
835     [59, kg]
249     [70, kg]
387     [69, kg]
515     [70, kg]
Name: Bag.Weight, dtype: object

Since this looks good, we can save it to a variable.

split_bw = coffee_df['Bag.Weight'].str.split(' ')

We still have one problem, each element contains a list.

type(split_bw[0])

list

What we want is a DataFrame with two columns, one of the first value and one of the second value for each list.

A DataFrame is build of Series which are each row (and each column) the lists we have are each the content that we want to put in one Series and then stack them all together.

To do this, we can cast each list to a Series using the apply method which automatically stacks Series or DataFrames back together after applying a function to each row (or column).

Recall that in python, we can use types as functions to cast

num = '2'

type(int(num))

int

type(num)

str

So, back to our real problem:

split_bw.apply(pd.Series)
0 1
0 60 kg
1 60 kg
2 1 NaN
3 60 kg
4 60 kg
... ... ...
1306 1 kg
1307 2 kg
1308 69 kg
1309 1 kg
1310 69 kg

1311 rows × 2 columns

This looks good, but these columns are not very informative, so we can rename them.

Rename can take many different inputs and be applied on lots of parts, but we will use it with a dictionary that serves as a mapping (like the mathematical sense of mapping; like a function). It will change the column with each key to the value.

split_df = split_bw.apply(pd.Series).rename(columns={0:'Weight',1:'Units'})
split_df
Weight Units
0 60 kg
1 60 kg
2 1 NaN
3 60 kg
4 60 kg
... ... ...
1306 1 kg
1307 2 kg
1308 69 kg
1309 1 kg
1310 69 kg

1311 rows × 2 columns

This is good, but it’s only the one column. We can use concat to put them together.

pd.concat([coffee_df,split_df],axis=1).head(2)
Unnamed: 0 Species Owner Country.of.Origin Farm.Name Lot.Number Mill ICO.Number Company Altitude ... Expiration Certification.Body Certification.Address Certification.Contact unit_of_measurement altitude_low_meters altitude_high_meters altitude_mean_meters Weight Units
0 1 Arabica metad plc Ethiopia metad plc NaN metad plc 2014/2015 metad agricultural developmet plc 1950-2200 ... April 3rd, 2016 METAD Agricultural Development plc 309fcf77415a3661ae83e027f7e5f05dad786e44 19fef5a731de2db57d16da10287413f5f99bc2dd m 1950.0 2200.0 2075.0 60 kg
1 2 Arabica metad plc Ethiopia metad plc NaN metad plc 2014/2015 metad agricultural developmet plc 1950-2200 ... April 3rd, 2016 METAD Agricultural Development plc 309fcf77415a3661ae83e027f7e5f05dad786e44 19fef5a731de2db57d16da10287413f5f99bc2dd m 1950.0 2200.0 2075.0 60 kg

2 rows × 46 columns

Why axis=1 again?

Let’s look at the other one.

bad_concat = pd.concat([coffee_df,split_df],axis=0)
bad_concat.shape

(2622, 46)

It has double the rows

Important

checking the shape is the first thing to do to see if you did the right one

and the bottom of it most columns are NaN (null, missing)

bad_concat.tail()
Unnamed: 0 Species Owner Country.of.Origin Farm.Name Lot.Number Mill ICO.Number Company Altitude ... Expiration Certification.Body Certification.Address Certification.Contact unit_of_measurement altitude_low_meters altitude_high_meters altitude_mean_meters Weight Units
1306 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN 1 kg
1307 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN 2 kg
1308 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN 69 kg
1309 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN 1 kg
1310 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN 69 kg

5 rows × 46 columns

9.4. Unpacking Jsons#

rhodyprog4ds_gh_events_url = 'https://api.github.com/orgs/rhodyprog4ds/events'

course_gh_df = pd.read_json(rhodyprog4ds_gh_events_url)
course_gh_df.head()
id type actor repo payload public created_at org
0 25983496729 PushEvent {'id': 10656079, 'login': 'brownsarahm', 'disp... {'id': 532028859, 'name': 'rhodyprog4ds/BrownF... {'push_id': 12047706003, 'size': 1, 'distinct_... True 2022-12-19 21:12:05+00:00 {'id': 69595187, 'login': 'rhodyprog4ds', 'gra...
1 25943982635 PushEvent {'id': 41898282, 'login': 'github-actions[bot]... {'id': 532028859, 'name': 'rhodyprog4ds/BrownF... {'push_id': 12025213311, 'size': 1, 'distinct_... True 2022-12-16 21:42:14+00:00 {'id': 69595187, 'login': 'rhodyprog4ds', 'gra...
2 25943825627 PushEvent {'id': 10656079, 'login': 'brownsarahm', 'disp... {'id': 532028859, 'name': 'rhodyprog4ds/BrownF... {'push_id': 12025131284, 'size': 1, 'distinct_... True 2022-12-16 21:31:27+00:00 {'id': 69595187, 'login': 'rhodyprog4ds', 'gra...
3 25872136902 PushEvent {'id': 41898282, 'login': 'github-actions[bot]... {'id': 532028859, 'name': 'rhodyprog4ds/BrownF... {'push_id': 11989885243, 'size': 1, 'distinct_... True 2022-12-14 04:00:44+00:00 {'id': 69595187, 'login': 'rhodyprog4ds', 'gra...
4 25872131897 PushEvent {'id': 41898282, 'login': 'github-actions[bot]... {'id': 532028859, 'name': 'rhodyprog4ds/BrownF... {'push_id': 11989882657, 'size': 1, 'distinct_... True 2022-12-14 04:00:20+00:00 {'id': 69595187, 'login': 'rhodyprog4ds', 'gra...

We want to transform each one of those from a dictionary like thing into a row in a data frame.

type(course_gh_df['actor'])

pandas.core.series.Series

Recall, that base python types can be used as function, to cast an object from type to another.

5

5

type(5)

int

str(5)

'5'

To unpack one column we can cast each element of the column to a series and then stack them back together.

First, let’s look at one row of one column

course_gh_df['actor'][0]

{'id': 10656079,
 'login': 'brownsarahm',
 'display_login': 'brownsarahm',
 'gravatar_id': '',
 'url': 'https://api.github.com/users/brownsarahm',
 'avatar_url': 'https://avatars.githubusercontent.com/u/10656079?'}

Now let’s cast it to a Series

pd.Series(course_gh_df['actor'][0])

id                                                        10656079
login                                                  brownsarahm
display_login                                          brownsarahm
gravatar_id                                                       
url                       https://api.github.com/users/brownsarahm
avatar_url       https://avatars.githubusercontent.com/u/10656079?
dtype: object

What we want is to do this over and over and stack them.

The apply method does this for us, in one compact step.

course_gh_df['actor'].apply(pd.Series)
id login display_login gravatar_id url avatar_url
0 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
1 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282?
2 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
3 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282?
4 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282?
5 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
6 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
7 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
8 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
9 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282?
10 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
11 69595187 rhodyprog4ds rhodyprog4ds https://api.github.com/users/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
12 17578666 andresavage andresavage https://api.github.com/users/andresavage https://avatars.githubusercontent.com/u/17578666?
13 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282?
14 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
15 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282?
16 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
17 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
18 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
19 119482217 thuthaont thuthaont https://api.github.com/users/thuthaont https://avatars.githubusercontent.com/u/119482...
20 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282?
21 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
22 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282?
23 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
24 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
25 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
26 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282?
27 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
28 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?
29 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079?

How can we do this for all of the columns and put them back together after?

First, let’s make a list of the columns we need to convert.

js_cols = ['actor','repo','payload','org']

When we use .apply(pd.Series) we get a a DataFrame.

type(course_gh_df['actor'].apply(pd.Series))

pandas.core.frame.DataFrame

pd.concat takes a list of DataFrames and puts the together in one DataFrame.

to illustrate, it’s nice to make small dataFrames.

df1 = pd.DataFrame([[1,2,3],[3,4,7]], columns = ['A','B','t'])
df2 = pd.DataFrame([[10,20,30],[30,40,70]], columns = ['AA','BB','t'])
df1
A B t
0 1 2 3
1 3 4 7 
df2
AA BB t
0 10 20 30
1 30 40 70

If we use concat with the default settings, it stacks them vertically and aligns any columns that have the same name.

pd.concat([df1,df2])
A B t AA BB
0 1.0 2.0 3 NaN NaN
1 3.0 4.0 7 NaN NaN
0 NaN NaN 30 10.0 20.0
1 NaN NaN 70 30.0 40.0

So, since the original DataFrames were both 2 rows with 3 columns each, with one column name appearing in both, we end up with a new DataFrame with shape (4,5) and it fills with NaN in the top right and the bottom left.

pd.concat([df1,df2]).shape

(4, 5)

We can use the axis parameter to tell it how to combine them. The default is axis=0, but axis=1 will combine along rows.

pd.concat([df1,df2], axis =1)
A B t AA BB t
0 1 2 3 10 20 30
1 3 4 7 30 40 70

So now we get no NaN values, because both DataFrames have the same number of rows and the same index.

df1.index == df2.index

array([ True,  True])

and we have a total of 6 columns and 2 rows.

pd.concat([df1,df2], axis =1).shape

(2, 6)

Back to our gh data, we want to make a list of DataFrames where each DataFrame corresponds to one of the columns in the original DataFrame, but unpacked and then stack them horizontally (axis=1) because each DataFrame in the list is based on the same original DataFrame, they again have the same index.

pd.concat([course_gh_df[cur_col].apply(pd.Series) for cur_col in js_cols],
         axis=1)
id login display_login gravatar_id url avatar_url id name url push_id ... master_branch description pusher_type member forkee id login gravatar_id url avatar_url
0 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.204771e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
1 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.202521e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
2 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.202513e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
3 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198989e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
4 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198988e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
5 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
6 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
7 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198984e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
8 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198984e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
9 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.197084e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
10 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.197072e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
11 69595187 rhodyprog4ds rhodyprog4ds https://api.github.com/users/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187? 576430088 rhodyprog4ds/hands-on-sql-3086685 https://api.github.com/repos/rhodyprog4ds/hand... NaN ... NaN NaN NaN {'login': 'stubbsdiondra', 'id': 83089796, 'no... NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
12 17578666 andresavage andresavage https://api.github.com/users/andresavage https://avatars.githubusercontent.com/u/17578666? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN {'id': 575613543, 'node_id': 'R_kgDOIk8qZw', '... 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
13 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190800e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
14 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190793e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
15 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190790e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
16 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
17 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
18 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190784e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
19 119482217 thuthaont thuthaont https://api.github.com/users/thuthaont https://avatars.githubusercontent.com/u/119482... 287067905 rhodyprog4ds/portfolio-template https://api.github.com/repos/rhodyprog4ds/port... NaN ... NaN NaN NaN NaN {'id': 572439723, 'node_id': 'R_kgDOIh68qw', '... 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
20 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.177541e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
21 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.177532e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
22 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.176980e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
23 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
24 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
25 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.176974e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
26 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.174295e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
27 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
28 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
29 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.174288e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?

30 rows × 29 columns

Try it Yourself

examine the list of DataFrames to see what structure they share and do not share

In this case we get the same 30 rows, beacuse that’s what the API gave us and turned our 4 columns from js_cols into 26 columns.

pd.concat([course_gh_df[cur_col].apply(pd.Series) for cur_col in js_cols],
         axis=1).shape

(30, 29)

If we had used the default, we’d end up with 120 rows (30*4) and we have only 19 columns, because there are subfield names that are shared across the original columns. (eg most have an id)

pd.concat([course_gh_df[cur_col].apply(pd.Series) for cur_col in js_cols],
         axis=0).shape

(120, 22)

we might want to rename the new columns so that they have the original column name prepended to the new name. This will help us distinguish between the different id columns

pandas has a rename method for this.

and this is another job for lambdas.

pd.concat([course_gh_df[cur_col].apply(pd.Series).rename(columns = lambda c: cur_col + '_' +c)
           for cur_col in js_cols],
         axis=1)
actor_id actor_login actor_display_login actor_gravatar_id actor_url actor_avatar_url repo_id repo_name repo_url payload_push_id ... payload_master_branch payload_description payload_pusher_type payload_member payload_forkee org_id org_login org_gravatar_id org_url org_avatar_url
0 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.204771e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
1 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.202521e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
2 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.202513e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
3 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198989e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
4 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198988e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
5 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
6 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
7 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198984e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
8 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198984e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
9 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.197084e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
10 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.197072e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
11 69595187 rhodyprog4ds rhodyprog4ds https://api.github.com/users/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187? 576430088 rhodyprog4ds/hands-on-sql-3086685 https://api.github.com/repos/rhodyprog4ds/hand... NaN ... NaN NaN NaN {'login': 'stubbsdiondra', 'id': 83089796, 'no... NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
12 17578666 andresavage andresavage https://api.github.com/users/andresavage https://avatars.githubusercontent.com/u/17578666? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN {'id': 575613543, 'node_id': 'R_kgDOIk8qZw', '... 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
13 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190800e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
14 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190793e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
15 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190790e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
16 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
17 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
18 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190784e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
19 119482217 thuthaont thuthaont https://api.github.com/users/thuthaont https://avatars.githubusercontent.com/u/119482... 287067905 rhodyprog4ds/portfolio-template https://api.github.com/repos/rhodyprog4ds/port... NaN ... NaN NaN NaN NaN {'id': 572439723, 'node_id': 'R_kgDOIh68qw', '... 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
20 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.177541e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
21 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.177532e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
22 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.176980e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
23 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
24 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
25 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.176974e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
26 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.174295e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
27 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
28 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
29 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.174288e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?

30 rows × 29 columns

the rename method’s column parameter can take a lambda defined inline, which is helpful, because we want that function to take one parameter (the current columnt name) and do the same thing to all of the columns within a single DataFrame, but to prepend a different thing for each DataFrame

pd.concat([course_gh_df[cur_col].apply(pd.Series).rename(columns = lambda c: cur_col + '_' +c)
           for cur_col in js_cols],
         axis=1)
actor_id actor_login actor_display_login actor_gravatar_id actor_url actor_avatar_url repo_id repo_name repo_url payload_push_id ... payload_master_branch payload_description payload_pusher_type payload_member payload_forkee org_id org_login org_gravatar_id org_url org_avatar_url
0 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.204771e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
1 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.202521e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
2 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.202513e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
3 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198989e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
4 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198988e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
5 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
6 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
7 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198984e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
8 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.198984e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
9 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.197084e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
10 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.197072e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
11 69595187 rhodyprog4ds rhodyprog4ds https://api.github.com/users/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187? 576430088 rhodyprog4ds/hands-on-sql-3086685 https://api.github.com/repos/rhodyprog4ds/hand... NaN ... NaN NaN NaN {'login': 'stubbsdiondra', 'id': 83089796, 'no... NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
12 17578666 andresavage andresavage https://api.github.com/users/andresavage https://avatars.githubusercontent.com/u/17578666? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN {'id': 575613543, 'node_id': 'R_kgDOIk8qZw', '... 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
13 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190800e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
14 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190793e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
15 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190790e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
16 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
17 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
18 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.190784e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
19 119482217 thuthaont thuthaont https://api.github.com/users/thuthaont https://avatars.githubusercontent.com/u/119482... 287067905 rhodyprog4ds/portfolio-template https://api.github.com/repos/rhodyprog4ds/port... NaN ... NaN NaN NaN NaN {'id': 572439723, 'node_id': 'R_kgDOIh68qw', '... 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
20 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.177541e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
21 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.177532e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
22 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.176980e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
23 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
24 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
25 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.176974e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
26 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.174295e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
27 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
28 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... NaN ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
29 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? 532028859 rhodyprog4ds/BrownFall22 https://api.github.com/repos/rhodyprog4ds/Brow... 1.174288e+10 ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?

30 rows × 29 columns

So now, we have the unpacked columns with good column names, but we lost the columns that were originally good.

How can we append the new columns to the old ones? First we can make a DataFrame that’s just the columns not on the list that we’re goign to expand.

course_gf_df_good = course_gh_df[[col for col in
          course_gh_df.columns if not(col in js_cols)]]
course_gf_df_good
id type public created_at
0 25983496729 PushEvent True 2022-12-19 21:12:05+00:00
1 25943982635 PushEvent True 2022-12-16 21:42:14+00:00
2 25943825627 PushEvent True 2022-12-16 21:31:27+00:00
3 25872136902 PushEvent True 2022-12-14 04:00:44+00:00
4 25872131897 PushEvent True 2022-12-14 04:00:20+00:00
5 25872088863 ReleaseEvent True 2022-12-14 03:56:34+00:00
6 25872058273 CreateEvent True 2022-12-14 03:53:56+00:00
7 25872053767 PushEvent True 2022-12-14 03:53:31+00:00
8 25872040714 PushEvent True 2022-12-14 03:52:24+00:00
9 25832860080 PushEvent True 2022-12-12 17:17:07+00:00
10 25832610823 PushEvent True 2022-12-12 17:07:27+00:00
11 25786395843 MemberEvent True 2022-12-09 20:58:22+00:00
12 25734197812 ForkEvent True 2022-12-07 22:57:27+00:00
13 25707552350 PushEvent True 2022-12-07 02:31:25+00:00
14 25707409089 PushEvent True 2022-12-07 02:21:11+00:00
15 25707350606 PushEvent True 2022-12-07 02:17:06+00:00
16 25707319331 ReleaseEvent True 2022-12-07 02:14:59+00:00
17 25707286223 CreateEvent True 2022-12-07 02:12:45+00:00
18 25707236522 PushEvent True 2022-12-07 02:09:26+00:00
19 25559123842 ForkEvent True 2022-11-30 09:26:11+00:00
20 25454470489 PushEvent True 2022-11-24 13:07:35+00:00
21 25454293906 PushEvent True 2022-11-24 13:00:08+00:00
22 25443448383 PushEvent True 2022-11-24 02:14:06+00:00
23 25443372137 ReleaseEvent True 2022-11-24 02:07:04+00:00
24 25443352568 CreateEvent True 2022-11-24 02:05:18+00:00
25 25443343932 PushEvent True 2022-11-24 02:04:31+00:00
26 25390211963 PushEvent True 2022-11-22 02:55:20+00:00
27 25390113561 ReleaseEvent True 2022-11-22 02:47:58+00:00
28 25390087086 CreateEvent True 2022-11-22 02:45:58+00:00
29 25390070156 PushEvent True 2022-11-22 02:44:44+00:00

Then we can prepend that to the list that we pass to concat. We have to put it in a list first, then use + to do that.

pd.concat([course_gf_df_good]+[course_gh_df[col].apply(pd.Series,).rename(
  columns= lambda i_col: col + '_' + i_col )
      for col in js_cols],axis=1)
id type public created_at actor_id actor_login actor_display_login actor_gravatar_id actor_url actor_avatar_url ... payload_master_branch payload_description payload_pusher_type payload_member payload_forkee org_id org_login org_gravatar_id org_url org_avatar_url
0 25983496729 PushEvent True 2022-12-19 21:12:05+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
1 25943982635 PushEvent True 2022-12-16 21:42:14+00:00 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
2 25943825627 PushEvent True 2022-12-16 21:31:27+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
3 25872136902 PushEvent True 2022-12-14 04:00:44+00:00 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
4 25872131897 PushEvent True 2022-12-14 04:00:20+00:00 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
5 25872088863 ReleaseEvent True 2022-12-14 03:56:34+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
6 25872058273 CreateEvent True 2022-12-14 03:53:56+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
7 25872053767 PushEvent True 2022-12-14 03:53:31+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
8 25872040714 PushEvent True 2022-12-14 03:52:24+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
9 25832860080 PushEvent True 2022-12-12 17:17:07+00:00 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
10 25832610823 PushEvent True 2022-12-12 17:07:27+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
11 25786395843 MemberEvent True 2022-12-09 20:58:22+00:00 69595187 rhodyprog4ds rhodyprog4ds https://api.github.com/users/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187? ... NaN NaN NaN {'login': 'stubbsdiondra', 'id': 83089796, 'no... NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
12 25734197812 ForkEvent True 2022-12-07 22:57:27+00:00 17578666 andresavage andresavage https://api.github.com/users/andresavage https://avatars.githubusercontent.com/u/17578666? ... NaN NaN NaN NaN {'id': 575613543, 'node_id': 'R_kgDOIk8qZw', '... 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
13 25707552350 PushEvent True 2022-12-07 02:31:25+00:00 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
14 25707409089 PushEvent True 2022-12-07 02:21:11+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
15 25707350606 PushEvent True 2022-12-07 02:17:06+00:00 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
16 25707319331 ReleaseEvent True 2022-12-07 02:14:59+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
17 25707286223 CreateEvent True 2022-12-07 02:12:45+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
18 25707236522 PushEvent True 2022-12-07 02:09:26+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
19 25559123842 ForkEvent True 2022-11-30 09:26:11+00:00 119482217 thuthaont thuthaont https://api.github.com/users/thuthaont https://avatars.githubusercontent.com/u/119482... ... NaN NaN NaN NaN {'id': 572439723, 'node_id': 'R_kgDOIh68qw', '... 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
20 25454470489 PushEvent True 2022-11-24 13:07:35+00:00 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
21 25454293906 PushEvent True 2022-11-24 13:00:08+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
22 25443448383 PushEvent True 2022-11-24 02:14:06+00:00 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
23 25443372137 ReleaseEvent True 2022-11-24 02:07:04+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
24 25443352568 CreateEvent True 2022-11-24 02:05:18+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
25 25443343932 PushEvent True 2022-11-24 02:04:31+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
26 25390211963 PushEvent True 2022-11-22 02:55:20+00:00 41898282 github-actions[bot] github-actions https://api.github.com/users/github-actions[bot] https://avatars.githubusercontent.com/u/41898282? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
27 25390113561 ReleaseEvent True 2022-11-22 02:47:58+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
28 25390087086 CreateEvent True 2022-11-22 02:45:58+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... main Course website repo user NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?
29 25390070156 PushEvent True 2022-11-22 02:44:44+00:00 10656079 brownsarahm brownsarahm https://api.github.com/users/brownsarahm https://avatars.githubusercontent.com/u/10656079? ... NaN NaN NaN NaN NaN 69595187 rhodyprog4ds https://api.github.com/orgs/rhodyprog4ds https://avatars.githubusercontent.com/u/69595187?

30 rows × 33 columns