From junior to geek the road is sleek
Best way is to use Panda’s to_csv() built-in function df.to_csv(‘filename’, index=False) Don’t forget to pass index=False as a second parameter if you don’t want index row saved as a column (in other words use it if you don’t want duplicated index when opening the file again). By the way, you can also withhold column names … Read more
I always keep forgetting how exactly with statement works with opening and reading the files in Python. path = ‘./path/filename.txt’ with open(path,’r’) as file: data = file.readlines() print(data) Or if you would like to avoid getting ‘\n’ after each line when using .readlines() you can use this instead: data = file.read().splitlines() Opening files with ‘with’ … Read more
First you might think in order to print dictionary values it’s enough to: for i in dict: print(i) But No. This way it’ll only print the keys. In order to print values next to the dictionary keys use: for key in dict: print(key, ‘-‘, dict[key])
For all noobs like me. If you get this error, you most probably doing one stupid thing like I did: where y2.shape[0] is just an integer. Remember, we can iterate only through lists or other sequences. When we would like to repeat a certain action X number of times we should do the following: If … Read more
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
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