How to convert an XML file to nice pandas dataframe?
Let’s assume that I have an XML like this:
pandas
How to save a new sheet in an existing excel file, using Pandas?
I want to use excel files to store data elaborated with python. My problem is that I can’t add sheets to an existing excel file. Here I suggest a sample code to work with in order to reach this issue
How to display pandas DataFrame of floats using a format string for columns?
I would like to display a pandas dataframe with a given format using print() and the IPython display(). For example:
Fast punctuation removal with pandas
This is a self-answered post. Below I outline a common problem in the NLP domain and propose a few performant methods to solve it.
Replace values in a pandas series via dictionary efficiently
How to replace values in a Pandas series s via a dictionary d has been asked and re-asked many times.
Pandas read_csv low_memory and dtype options
When calling
How to pivot a dataframe in Pandas?
I have a table in csv format that looks like this. I would like to transpose the table so that the values in the indicator name column are the new columns, Indicator Country Year Value 1 Angola 2005 6 2 Angola 2005 13 3 Angola 2005 10 4 Angola 2005 11 5 Angola 2005 5 … Read more
Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
You can use the function tz_localize to make a Timestamp or DateTimeIndex timezone aware, but how can you do the opposite: how can you convert a timezone aware Timestamp to a naive one, while preserving its timezone?
Format / Suppress Scientific Notation from Pandas Aggregation Results
How can one modify the format for the output from a groupby operation in pandas that produces scientific notation for very large numbers?
Find row where values for column is maximal in a pandas DataFrame
How can I find the row for which the value of a specific column is maximal?