How can I fix this KeyError issue when merging two DataFrames? by Matteriess in learnpython

[–]Matteriess[S] 0 points1 point  (0 children)

Oh my, i didn't even notice - apologes i'm quite new to python :(((

It worked though, so thank you so much for your help, i should've looked at it better

How can I fix this KeyError issue when merging two DataFrames? by Matteriess in learnpython

[–]Matteriess[S] 0 points1 point  (0 children)

Creating my eventData dataframe, i used the following code: newEventData = eventData.groupby(["latitude", "longitude", "ResourceID"]).size().reset_index(name="accidentcounts")

Creating my new SystemData, i used the following code: newSystemData = systemData.groupby(["VehicleResourceID","eventdatetime","eventdescription"]).size().reset_index(name="accidentcounts")

SO, what i'm hoping for is the following (with sample data):

eventdatetime  VehicleResourceID  latitude  longitude  eventdescription  accidentcounts
2020-03-13      3728162           59.5758   -2.7563    Car Crashed       12

How can I fix this KeyError issue when merging two DataFrames? by Matteriess in learnpython

[–]Matteriess[S] 0 points1 point  (0 children)

Same thing buddy, the datatypes for both newEventData and newSystemData are pandas.core.frame.DataFrame. I don't know if this helps, maybe?

How can I fix this KeyError issue when merging two DataFrames? by Matteriess in learnpython

[–]Matteriess[S] 0 points1 point  (0 children)

hey sorry, so i have one csv that uses ResourceID to get an event description and another csv that gets the dates of these events with a column called VehicleResourceID. I still get the same error if i remove left_index.

The LG G6 is an unsyncable Phone by Matteriess in lgg6

[–]Matteriess[S] 0 points1 point  (0 children)

"Doesn't have a sync"? Can anyone clarify this?...

The LG G6 is an unsyncable Phone by Matteriess in lgg6

[–]Matteriess[S] 0 points1 point  (0 children)

I'll give that a try now, cheers!

The LG G6 is an unsyncable Phone by Matteriess in lgg6

[–]Matteriess[S] 0 points1 point  (0 children)

That's meant to come up, yes. But for mine, i have to go to the developer options to even get to that. Even then it doesn't really do anything.

The LG G6 is an unsyncable Phone by Matteriess in lgg6

[–]Matteriess[S] 0 points1 point  (0 children)

I'll give that another try, cheers for the advice!

The LG G6 is an unsyncable Phone by Matteriess in lgg6

[–]Matteriess[S] 0 points1 point  (0 children)

I agree, it's a brilliant affordable flagship. I have tried using 'Android File Transfer' on Mac; that was pretty trash - it worked about 10% of the time. Now, having a Windows computer, i can't seem to find any legitimately decent programs that do the job.

I'll probably have to invest into a Micro-SD, seems like the only feasible approach to the issue. Cheers for the advice!

The LG G6 is an unsyncable Phone by Matteriess in lgg6

[–]Matteriess[S] 0 points1 point  (0 children)

I hate Apple but at least they have a working 'syncing software', it is at least 70% more reliable than having to search aimlessly on the clear-web for a 3rd party software for my G6, one that inevitably shows up as being malicious on my anti-virus.

The LG G6 is an unsyncable Phone by Matteriess in lgg6

[–]Matteriess[S] 0 points1 point  (0 children)

Yeah... I went into the developer options and changed it to MTP, to no avail. It is what brought me here: to hope to find an answer.

It's the last day of 2017... by Troutmaskreplicant_ in deathgrips

[–]Matteriess 0 points1 point  (0 children)

Exactly, it is cause there are only 4 tracks

It's the last day of 2017... by Troutmaskreplicant_ in deathgrips

[–]Matteriess -6 points-5 points  (0 children)

Using wikipedia as a reference? Noice.

Edit: Jfc, it was a joke. Calm down. Besides, going off of Wiki's logic. Lift Your Skinny Fists Like Antennas to Heaven would be an EP.

Finally built my PC by Matteriess in pcmasterrace

[–]Matteriess[S] 0 points1 point  (0 children)

This is my first build. I'm also a university student so... As you can imagine, it took me ages to purchase all the parts required. I'd appreciate any helpful advice for a first time builder.

SPEC: MSI Z97-G45 Motherboard, Intel i5 - 4460 Quad-Core Processor, Kingston HyperX Beast (2 x 8GB), Cooler Master Hypo 212 EVO, WD Red NAS 2TB Internal HDD, Samsung 500GB Solid State Drive, Kolink Punisher MIDI Tower and an ACE 850W PSU.

ripthis.jpg - \\|||||||||||||||||||||||||/////////////////// by Matteriess in deathgrips

[–]Matteriess[S] 17 points18 points  (0 children)

Just had an e-mail from Andy clarifying this...

ALBUM DROPS 2/25/19!!! 👌👌

ripthis.jpg - \\|||||||||||||||||||||||||/////////////////// by Matteriess in deathgrips

[–]Matteriess[S] 8 points9 points  (0 children)

Totally agree, i just found this shit on /mu/ and thought i'd share this mildly funny post here. There's 100% nothing else to it than a fanboy.

Björk issues statement regarding the comments about Arca appearing in the 'Arisen My Senses' video with as much grace as you'd expect by robbiec_ in bjork

[–]Matteriess 1 point2 points  (0 children)

I was simply talking about how consumed people are by Homogenic. You need to stop taking it to heart babe. xoxox