Can anyone pinpoint me to the best books on data structures on C? Please recommend comprehensive ones.
There are good data structure books and good C books, but there's really no point in trying to combine them. If you are having trouble translating the pseudocode from a good algorithms/data structures book into C, I don't think your real problem will be alleviated by having examples in C.
If you just want implementations in C to use as-is or to study, you could take a look at Generic Data Structures Library or Comprehensive C Archive Network for reusable code. These are likely to be more robust than code that will fit in the constraints of textbook examples, anyway.
Introduction to Algorithms is a well-regarded textbook on algorithms and data structures and will teach you about most general-purpose structures as well as some more esoteric ones, but to approach anywhere near a comprehensive knowledge of data structures you'd have to branch into more specialist textbooks and papers. It's a pretty massive field of knowledge.
I learned using Mastering Algorithms with C a while back. It is a great book that walks you through implementing several data structures from scratch.