• Home
  • Blog
  • Resume
  • Contact
  • Projects
  • Gallery
  • Amit’s Resume
  • About Nagpur
KEEP IN TOUCH

The search key was not found in any record in Access

Sep15
2009
20 Comments Written by admin

Well, I got this error message today while I was trying to import a text file:

“The search key was not found in any record”

After some research, I found that either it was a bug caused by Microsoft Jet 4.0 Service Pack or it was the size of the database (should be not greater than 2GB). It turned out to be the later one. I fixed this problem by compacting and resizing the database. In Access 2007, you click on the Office Button (Top Left Corner), then Manage > Compact and Repair Database.

Posted in Access, Error messages - Tagged Access, error, Microsoft Jet

Tag Cloud of Data Mining Jobs

Aug20
2009
Leave a Comment Written by admin

Here’s what I did to get a cool looking tag cloud of data mining jobs:

  1. Used Yahoo Pipes (I created mine, but this one has more feeds)– this pipe aggregates feeds from different job web-sites, and gives the user unique job listing that you can subscribe via RSS: Job Feed Aggregator by Sean Dolan
  2. Subscribed to the RSS feed for the keyword “data mining”
  3. Copied the job descriptions and requirements of many jobs, and saved the text file
  4. Got the python stemmer
  5. Applied the python stemmer to the text file. Stemmer truncates words to their roots, so that we can combine variants of a word into a single word. (First or second step in text mining)
  6. Created a tag cloud using the services of http://www.wordle.net/ . They use “stop words,” so I didn’t have to apply those. Stop words are common words, which necessarily don’t add any value for categorization, of a language.
Data Mining Jobs Tag Cloud

Data Mining Jobs Tag Cloud


The most frequent word is: experience. Companies want people with experience in different data mining techniques. You’ll see that some other big words are: SAS (stemmed as sa), Excel, SQL, analytical skills, statistics, and quantitative skills.

And how do you master these skills, you ask?

  1. Get a graduate degree in statistics, economics, mathematics, computer science, financial engineering, or industrial engineering with emphasis on databases, data mining, and marketing.
  2. Successfully complete data mining projects using free, open-source data mining tools, such as Weka, R, Orange, Rapid-Miner.
  3. Participate in data mining competitions. SAS’s data mining conference has a data mining competition every year.

Have a look at a detailed study by Pejic Bach, M: Creating profile of data mining specialist

Posted in Uncategorized - Tagged data mining, pipes, python, stemming, tag cloud, text mining, visualization

Auto Filter Cursor Movement

Jun01
2009
Leave a Comment Written by admin

Don’t you hate it when you are working with many fields and you want to filter a particular field, so you apply auto filter on the all fields, but you find out that the field you were working on is gone from your sight and you see A1 cell. I did. Not anymore.

Solution: Simply hit the left or the right arrow key, and it will take you to the left or the right cell of the field you were working on.

Posted in Uncategorized - Tagged cursor, excel, filter

Things they didn’t teach in school

May22
2009
Leave a Comment Written by admin

My gripe about graduate school is that the school focused on well-established software and never embraced nor encouraged open-source software. If they had taught, or at least introduced, these following open-source software, it would have helped us immensely to produce the best looking reports with great data analysis. We, however, had to struggle with SAS/Excel to get the graphs and analysis needed, and then spend hours to perform formatting in Word. Why they didn’t teach us:

  1. LaTex: a powerful typeset editor, where you focus on writing and not on formatting. It takes care of all the headings, page numbering, figure/table/equation numbering, TOC, bibliography/citation, and more. Although the learning curve is rather steep, once you get the hang of it, life becomes so easy. For windows: you need to get MikTex and any LaTex editor, such as LEd, LyX, or WinEd
  2. R: awesome statistical package with wonderful graphics components. Producing stunning graphics and statistics has never been easy. It had me at summary. Any software that can do produce the following, just by giving summary(iris) command has to be great:
Summary produced by R of the iris data set

Summary produced by R of the iris data set

In my thesis, I had plenty of equations, and every time I made some significant changes, MS Word happily would turn those equations into empty white boxes — and then I had to rewrite them. In retrospect, I find it ridiculous that I was entering citations manually. So every time I added a new reference, I would manually change the bibliography page and the page where I cited that reference. With LaTex, it is just a breeze to do all this.

Descriptive stats, Box-plots, normal curves, neural network, charts with LaTex equations, and a lot of more stuff, all could be easily done using R, and the best part is “repeatability.” With simple commands, you could export all the charts as images for various data sets or for various training algorithms. No sweat! Try that with Excel. (I did some years ago).

Posted in Uncategorized - Tagged charts, excel, LaTex, R, software, statistics

Data-Information Visualization

May21
2009
Leave a Comment Written by admin

Ever since I read the book The Visual Display of Quantitative Information, by Edward R. Tufte, I am captivated by the idea of creating good design while doing data analysis or dashboard building. Although Excel 2007 charts are much nicer than its previous births, I have started disliking Excel charts. I am even developing an eye for picking out the bad information pixels. Apart from Tufte’s books, these books have helped me immensely:

  • The Elements of Graphing Data, by William S. Cleveland
  • Information Dashboard Design, by Stephen Few

Administrators/executives neither have the time nor the patience to understand complicated data mining algorithms and its results, and when they don’t understand them most probably they will never go in “production.” Simple, yet informative, designs and charts have better chances of going in production, which I am sure every data miner longs for.

I found a course web-site on Information Visualization: http://www.stat.auckland.ac.nz/~ihaka/120/lectures.html

Posted in Books - Tagged Books, charts, dashboard, design, visualization
« Older Entries Newer Entries »

Tags

Access Alt F8 Books boxplot cells charts count cursor dashboard data mining dbase design error excel excel functions export filter flip LaTex MS query Number Err ODBC pipes Press Alt F11 Public Sub python R random numbers Range Cells report scripting software sparklines SQL SQL server stack columns statistics stemming string tag cloud text mining UDF VBA visualization wildcard

Network

View Ashutosh Nandeshwar's profile on LinkedIn

Recent Comments

  • larry on Access Export to Excel (2007)
  • Betty Chou on Projects
  • Rwill on Access Export to Excel (2007)
  • Bharathi on The search key was not found in any record in Access
  • Michael on The search key was not found in any record in Access

EvoLve theme by Blogatize  •  Powered by WordPress nandeshwar.info