Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

search a data frame in R

Posted on 2015-01-16
4
Medium Priority
?
216 Views
Last Modified: 2015-01-28
Hi,

I have created a data frame in R using the attached example. I stripped down some data so that I can attach the file. How can I search a Data frame in R by specifying values for columns TICKER and DCLRDT. Once the search is complete for that particular row I want to return the difference between columns RET and vwretd.

Thanks

0
Comment
Question by:camper12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 57

Expert Comment

by:giltjr
ID: 40555162
I can't help you, but just wanted to point out that it looks like you forgot to attach anything.
0
 

Author Comment

by:camper12
ID: 40555235
0
 
LVL 62

Accepted Solution

by:
gheist earned 1000 total points
ID: 40568051
I would go with RSQLite and make database from CSV, then use common SQL to retrieve parts of data you need.
0
 
LVL 62

Expert Comment

by:gheist
ID: 40576853
zoo can help too, though no huge advantage over sql...
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
As computers become more powerful, jobs will be replaced with artificial intelligence, leaving no place in the future for humans in the workforce. In the oncoming technological revolution, the staggering change to human mind labor will prove the ski…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question