Adding ‘how=’outer’ to ‘pd.merge()’ will actually do the job! Here’s a very good comprehensive article about Panda’s Join, Merge and Concatenate. And by the way, if you would like to fill NA values when merging, just add ‘.fillna(‘0′)’, in this case it will fill NA values with zeroes.
Results in beautiful Instead of Who’d want to format date like this… 😕
Turns out it’s quite simple if you know the right pandas methods. There’s a simple way to split categorical column into multiple columns with panda’s get_dummies. That is one separate column for each category. Yes, all done automatically. Now we have a bunch of columns with category name in the column names and 0’s and … Read more
It’s been a while since I’ve been using WordPress. It’s still my favourite blogging platforms, so I didn’t hesitate and chosen WP for my new blog that you are reading right now. I also really recommend it to anyone who want to create their own blog or website. It’s great! Now on to the issue … Read more
Hey guys. Being pretty average at Pandas, yesterday I stumbled upon a formatting challenge. I download some datasheets from the web for machine learning from time to time. This time I got some weird Time & date formatting which might’ve been good for regular use with Excel but unsuitable when it comes to Neural Networks: … Read more