3. Ask Anything Monday - Weekly Thread

Ask Anything Monday - Weekly Thread

Hi, I'm just getting started with Python and Pandas for data analysis and just had a question.

I have a df (teamdata)with a column (champions) that has five ID numbers in it that correspond to 5 names. I have a separate df (championdictionary) that has these ID numbers (key) and the corresponding actual names (id), is there a way I can lookup and replace the ID numbers with the names? I wrote this code to do it but it just replaces the fields with "nan" which I assume is an error message.

teamdata['champions'] = teamdata['champions'].map(championdictionary.set_index('key')['id'])

Note as well the ID numbers in df1 are separated by a space (eg. "10 312 54 12 321")

Could anyone give me some help with this one?

/r/learnpython Thread
Previous
Next

Recently removed from /r/learnpython

Advanced PDF to Excel with documents and example code NEED HELP WITH ASSIGNMENT ADVENTURE GAME BY MAY 1ST is naming variables with 1 letter a bad habit long term? Need Help With Python Webscraping!!! I have a single folder for pytesting. In the folder I have conftest.py. The problem is conftest.py is starting to get to big. What is the simplest way I can have multiple conftest.py or imports to conftest.py while still being able to run python -m pytest or pytest --capture=no? I'm lost in all these YT tutorials. How do I search for elements ONLY under a certain element? (Selenium) Rewriting code for project without global variables Import bs4 could not be resolved from source Pylance - Help? How is this wrong? Sorting students into a wanted number of groups. Question about "ethical" scraping How can I query if a webcam is in use without physically asking openCV to turn it on briefly and return an error if it's in use? Please help me Understand Classes. See below code. Program runs only half the time

More Random Comments

How do I tell my girlfriend her noises/moans during sex make me uncomfortable? Longer Message From Ske7ch The non-readers who don't know anything about the Dragon are lucky, I guess. Calling all remote sales professionals -- how much do you make? ELI5 Why technology is still stuck on 64bits? I was adopted, and not sure if I have C-PTSD. Or if it is justified. Any thoughts of what is happening with me? Or how to solve it? 7 LGBTQ+ Singaporeans Share The Housing Challenges They Face & Their Plans Around Them What’s your job and how much do you get paid? For my brown dudes who grew up in low-income families in the West, what was/is life like for you? What’s your job and how much do you get paid? To those who cut off some of their friends, how and why? LDAP and AD not working in Teampass Monday Majlis | Open Discussion Candace Owens makes up a person, lies about when college admissions results come out Counterarguments to: YoU JuSt WaNt a ShOt FoR sHoT...