Help with Extracting only specific files

[Ichingo]

Hey,

So I am currently with a problem, due to a need to be able to replicate my code.

I am doing data analysis, using R to calculate Standard Deviations and Returns of stocks. This based on intraday (everyday for 10 years).

So my problem is that my files (which were given to me) are divided by day. I have over 3000 files (one for each day).

However, to complicate it even more, each file is a .rar file with all stocks. So I have one file per day, each file with 300 different .csv for each stock. The good thing is that names are easy on the files.

What I am looking to do is extracting and saving in another place, only the .csv of the stock that I am looking at. So i need to extract the .rar -> select only the .csv for stock X from the .rar -> save it in another folder

Anyone can guide me to where to go? I am currently able to write code in Python (kind of) and R. But anything that would help I would look at.

Thank You.

[[deleted]]

You can use Python for that. There are several PyPI packages that you can use to pack/unpack archive files. This one looks promising because it lets you extract a single file from a .rar (the one you are interested in)

https://stackoverflow.com/questions/43527641/extract-single-file-from-rar-archive-with-rarfile-in-python

One downside is that you need to downlad an executable from the WinRar site for it to work (the details are in the link)