Python Forum
Why does newly-formed dict only consist of last row of each year?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Why does newly-formed dict only consist of last row of each year?
#1
Hi all,

I'm trying to convert two columns ('BIRTH_YEAR', 'NAME') of baby_names into a dictionary. Why does the newly-formed dictionary only consist of the last df row of each year?

baby_name_dict = {}
print(baby_names.info(), '\n')
baby_name_dict = dict(zip(baby_names.BIRTH_YEAR, baby_names.NAME))
print(f'baby_name_dict is:  {baby_name_dict}.')
Output:
<class 'pandas.core.frame.DataFrame'> RangeIndex: 13962 entries, 0 to 13961 Data columns (total 6 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 BIRTH_YEAR 13962 non-null int64 1 GENDER 13962 non-null object 2 ETHNICTY 13962 non-null object 3 NAME 13962 non-null object 4 COUNT 13962 non-null int64 5 RANK 13962 non-null int64 dtypes: int64(3), object(3) memory usage: 654.6+ KB None baby_name_dict is: {2011: 'ZEV', 2012: 'ZEV', 2013: 'Zev', 2014: 'Zev'}.
Getting myself ready for a really foolish oversight... :)
Reply


Messages In This Thread
Why does newly-formed dict only consist of last row of each year? - by Mark17 - Nov-13-2023, 08:10 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Trying to get year not the entire year & time mbrown009 2 1,063 Jan-09-2023, 01:46 PM
Last Post: snippsat
  Sort a dict in dict cherry_cherry 4 103,342 Apr-08-2020, 12:25 PM
Last Post: perfringo
  [gpxpy] "Error parsing XML: not well-formed (invalid token): line 1, column 1" Winfried 5 6,987 Jan-26-2020, 01:09 AM
Last Post: Winfried
  How to show newly added column to csv johnson54937 3 2,344 Jan-07-2020, 04:01 AM
Last Post: Larz60+
  How to eliminate magic squares formed by the same numbers, but permuted frame 7 3,848 May-09-2019, 11:28 AM
Last Post: frame
  FileNotFoundError in newly structured Python project PrateekG 0 2,510 May-23-2018, 06:20 AM
Last Post: PrateekG
  Help needed building newly released FOSS 'Meshroom' mStuff 0 2,696 Apr-29-2018, 10:54 AM
Last Post: mStuff
  Copy folders to newly created folder and append Filthy_McNasty 5 5,275 Feb-21-2017, 05:26 PM
Last Post: wavic

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020