Top "Data-munging" questions

The process of taking raw data and parsing, filtering, extracting, organizing, combining, cleaning or otherwise converting it into a consistent useable form for further processing or input to an algorithm or system.

Pandas merge two dataframes with different columns

I'm surely missing something simple here. Trying to merge two dataframes in pandas that have mostly the same column names, …

python pandas dataframe data-munging
Strip white spaces from CSV file

I need to stripe the white spaces from a CSV file that I read import csv aList=[] with open(self.…

python csv data-munging
How to convert a python datetime.datetime to excel serial date number

I need to convert dates into Excel serial numbers for a data munging script I am writing. By playing with …

python excel datetime data-munging
Python: in-memory object database which supports indexing?

I'm doing some data munging which would be quite a bit simpler if I could stick a bunch of dictionaries …

python database data-munging
Index - Match using Pandas

I have the following 2 data frames: df1 = pd.DataFrame({ 'dates': ['02-Jan','03-Jan','30-Jan'], 'currency': ['aud','gbp','eur'], …

python pandas dataframe lookup data-munging
How to move my pandas dataframe to d3?

I am new to Python and have worked my way through a few books on it. Everything is great, except …

pandas d3.js ipython data-munging
openxlsx::write.xlsx overwriting existing worksheet instead append

The openxlsx::write.xlsx function is overwriting spreadsheet instead of adding another tab. I tried do follow some orientations of …

r data-munging openxlsx
Reading csv file into a DataTable using C#?

I have a number of Python scripts I wrote a while back, to do some data munging. I need to …

c# data-munging