Hi! I try to isolate any columns about Fandango rating only. How to use regex to select columns i need in this case?
I used the
df.filter, but i can only put one condition, if I also want to select
FILM columns here, how do i write the code? i tried
pre_df.filter(regex=('Fan.*'),regex=('FI.*')) but it does not work.
Screen Link: https://app.dataquest.io/m/288/guided-project%3A-investigating-fandango-movie-ratings/2/understanding-the-data
What I expected to happen:
return FILM column and any columns contain Fandango