readxl icon indicating copy to clipboard operation
readxl copied to clipboard

subsetting columns when reading an Excel file

Open spedygiorgio opened this issue 1 year ago • 4 comments

May be possible to select in advance the useful columns, like the use_cols parameter in the Python pandas pd.read_excel method?

spedygiorgio avatar Oct 28 '22 07:10 spedygiorgio

Can you provide more detail on what use_cols does?

jennybc avatar Feb 09 '23 00:02 jennybc

It specifies which columns should be taken ( read and exposed)

Il gio 9 feb 2023, 01:07 Jennifer (Jenny) Bryan @.***> ha scritto:

Can you provide more detail on what use_cols does?

— Reply to this email directly, view it on GitHub https://github.com/tidyverse/readxl/issues/715#issuecomment-1423400813, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAGJNRULTEGP6C6OW5AZUN3WWQYLHANCNFSM6AAAAAARQZJCZY . You are receiving this because you authored the thread.Message ID: @.***>

spedygiorgio avatar Feb 09 '23 10:02 spedygiorgio

readxl already has many ways to specify which column you want to read. So how is this different?

jennybc avatar Feb 09 '23 16:02 jennybc

@jennybc sorry for late reply, may you provde an example?

spedygiorgio avatar Sep 30 '23 18:09 spedygiorgio