refractor to robust data manipulation in OpenItems data mining