data-cleaning_开发者

What's the best language/technique to perform advanced data cleansing and formatting on a SQL/MySQL/PostgreSQL table?

We have a bunch of utility scripts in Visual FoxPro, which we use to interactively cleanse/format data.We\'d like to start migrating this code to make use of other database platforms, like MySQL or SQ[详细]

2023-04-11 13:22 分类：问答

Regex replace characters in data

I am trying to clean some junked up data of special characters (allowing a few) but some still get through. I found a regex snippet earlier but does not remove some characters, like asterisks.[详细]

2023-04-05 02:52 分类：问答

Data cleansing : user entered database data tools

We got a database with some redundant, bad data. As example some names of articles have an uppercase开发者_如何学C lower-case difference, other a problem of accent, others a missing letter and so on.[详细]

2023-03-28 07:39 分类：问答

tool to extract data structures from unclean data

I have unstructured geneally unclean data in a database field. There are common structures which are consistent in the data[详细]

2023-02-20 14:51 分类：问答

Cleansing string / input in Coldfusion 9

I have been working with Coldfusion 9 lately (background in PHP primarily) and I am scratching my head trying to figure out how to \'clean/sanitize\' input / string that is user submitted.[详细]

2023-02-03 06:45 分类：问答

Blocking '0000-00-00' from MySQL Date Fields

I have a database where old code likes to insert \'0000-00-00\' in Date and DateTime columns instead of a real date. So I have the following two questions:[详细]

2023-01-19 10:59 分类：问答

Problem looking at data between 0 and -1

I\'m t开发者_如何学Pythonrying to write a program that cleans data, using Matlab. This program takes in the max and min that the data can be, and throws out data that is less than the min or greater t[详细]

2023-01-09 11:21 分类：问答

Fuzzy data matching for personal demographic information

Let\'s say I have a database filled with people with the following data elements: PersonID (meaningless surrogate autonumber)[详细]

2023-01-08 03:17 分类：问答

《Happening》MP3歌词-Olivia Broadfield？

Happening Olivia Broadfield 专辑：吸血鬼日记第4季电视原声带 The Vampire Diary Season 4(Original S开发者_如何学编程oundtrack)[详细]

2022-12-28 20:06 分类：问答

Django "comment_was_flagged" signal

This is my first time working with django signals and I would like to hook the \"comment_was_flagged\" signal provided by the comments app to notify me when a comment is flagged.[详细]

2022-12-25 17:26 分类：问答