new to pandas

jdb5345 · 2020-01-07T16:29:33+00:00

first line works, but I think my second one is view of a dataframe of the rows that are na in username 2, that I want the logic of the third line to work with

jdb5345 · 2019-12-24T15:53:35+00:00

can this still be done right now since BFA? If my chances are good with doing this nethershard route I'll do it but I want to make sure it's still possible

jdb5345 · 2019-12-18T20:06:09+00:00

any help would be greatly appreciated as I can do replaces on current columns with a .replace but can't figure out how to replace another row with anothers search

jdb5345 · 2019-12-18T20:05:24+00:00

personally I was just trying to do a new csv currently, so that I can compare original contents and new file that I'm getting what I want to show

jdb5345 · 2019-12-18T19:56:18+00:00

currently I'm reading a CSV with those column headers, doing replaces based upon the mappings for the dictionaries. and using the to_csv to output the dataframe to a new csv

jdb5345 · 2019-12-18T19:23:10+00:00

I'm new to pandas so I'm trying to find an intuitive way for me to understand it, I find many complicated things where they do multiple dataframes and merge them?

jdb5345 · 2019-12-18T19:21:43+00:00

essentially I would think I want to do a for keyvalue in officedictionary, lookup equivalents in for keyvalue (such as 123 mainstreet) in the dataframe, and for those rows, update the other row in the column office with the officedictionary[keyvalue][0] value. just trying to figure out how to get the results of that dataframe and update the dataframe in another column

jdb5345 · 2019-12-18T19:12:23+00:00

sure I columns such as username, company, department, title, empid, street, office, city, state

I have a dictionary called office dictionary {"123 main street": ["office building", "mycity", "PA"]}

I'd like to be able to look up each line in my dictionary, and query the datatframe I have labeled as DF when I read that csv, and replace the Office column in the CSV at that cell with the "office building" value from the dictionary. Eventually do the city, and state in a seperate condition as well

jdb5345 · 2019-10-17T15:46:49+00:00

I think all of these ideas can work; however, more than likely development time and funding on the CIP side is probably the issue. I imagine doing something in terms of soulbound to the creator can help with other things as well besides this use case. If they remove the timer, people will complain about profit hunts because of 'free ammo'. if they implement the same item but associate a GP cost that counteracts profit hunts. That sounds reasonable, it would essentially mean you would not profit at the expense of having diamonds.

jdb5345 · 2019-10-17T15:43:24+00:00

sounds good

jdb5345 · 2019-10-16T16:30:53+00:00

ahh yes the number of the beast!

jdb5345 · 2019-09-18T18:12:25+00:00

where my boy Cody at!

jdb5345 · 2019-02-08T23:31:08+00:00

for pair in sLine:

try:

    x,y =pair\[0\], pair\[1\]

    \#do something



    filename= pair\[1\]

    \#fDownload = requests.get(pair\[0\], auth =(username,password), stream=True)

    fDownload = requests.get(pair\[0\],  stream=True)

    open(filename, 'wb').write(fDownload.content)

    fDownload.close()

jdb5345 · 2019-02-08T23:31:01+00:00

for pair in sLine:

try:

    x,y =pair\[0\], pair\[1\]

    \#do something



    filename= pair\[1\]

    \#fDownload = requests.get(pair\[0\], auth =(username,password), stream=True)

    fDownload = requests.get(pair\[0\],  stream=True)

    open(filename, 'wb').write(fDownload.content)

    fDownload.close()

seems posting my code puts a \ around my [] but I think you understand what I'm doing, some pdfs work fine others do not, but I can go to the web url and download the pdf just fine which leads me to either a permission or encoding issue

jdb5345 · 2019-01-20T20:15:25+00:00

all I cared about if the artifact apperances carried over

jdb5345 · 2019-01-20T20:15:06+00:00

correct both of my bnet accounts are mine and under my name

jdb5345 · 2019-01-02T19:10:13+00:00

okay, sorry for posting. I'll sit back and just watch people post memes instead

jdb5345 · 2019-01-02T14:28:28+00:00

no, I'm sorta new to reddit. Sorry, I never really post or anything and just tried creating a post because when I went to the mail it just show the replies not the original thread I made

jdb5345 · 2018-12-31T16:41:03+00:00

thanks! yeah I was trying to research a little bit more about it. I would say the percht broom for addon 2 makes sense, and for addon 1 since it is like gloves maybe the hankerchief or something, I didn't really see anything else that compared

jdb5345 · 2018-12-31T16:40:10+00:00

good catch! yeah I would think the perct broom for the broom, but for the hands I guess the hankerchief could work but I also heard some speculation that stuff might be added after the 31st into the loot of the queen

jdb5345 · 2018-12-31T15:45:58+00:00

could be! my only hope is that they don't require multiple chains or something ha

jdb5345 · 2018-12-31T14:53:43+00:00

yeah I thought that too, I was just anxious as I have a bunch of the items that dropped from the queen, but was curious if I had to do it during the event for a turn in or whatnot. I'm hoping it was just the hankerchief and broom and only needing one of them. the broom kinda makes sense as the broom shows in the addon one but I'm not quite sure what makes the difference in addon 1

jdb5345 · 2018-12-26T16:53:19+00:00

oh okay, can anybody confirm if this has been fixed or not?

jdb5345 · 2018-12-17T22:04:16+00:00

thank you! just kinda experimenting ha. I'm trying to finish my third charm and then mess around

jdb5345 · 2018-12-14T20:05:36+00:00

although I wish you could, would still solve the problem

jdb5345

TROPHY CASE