You can contribute to this section by offering your own questions, answers, or clarifications on this exercise. Ask or answer a question by clicking reply () below.
If you’ve had an “aha” moment about the concepts, formatting, syntax, or anything else with this exercise, consider sharing those insights! Teaching others and answering their questions is one of the best ways to learn and stay sharp.
Join the Discussion. Help a fellow learner on their journey.
Ask or answer a question about this exercise by clicking reply () below!
Agree with a comment or answer? Like () to up-vote the contribution!
Having gone through the Pandas path, my question is: why don’t we just use concat() instead of glob()? What are the limitations of using one instead of the other
[name of library].[name of the method]
the glob library has no alias, so it is using its value.
if it was “import glob as test”, the call would be test.glob
hey
in this exercise, the regex * refers to everything that comes after *
quite like “random%” on SQL, that would match “random7627hckg” etc.
it has been confusing for me, since the cheetsheet says the regex * is A MULTIPLIER.
Id love to understand that clearly.
Thanks!
I have a recommendation regarding the lesson’s description on the glob module.
glob can open multiple files by using regex matching to get the filenames:
Shouldn’t it be “by glob-style matching”? It’s similar to regex but there are some important differences that can be pointed out by just seeing the examples, for example, the dots in the filenames aren’t treated as wildcards but as literal dots, which happens with glob-style matching instead of regex. Please take a look into this description in 3. Dealing with Multiple Files.
import glob
files = glob.glob("file*.csv")
df_list = []
for filename in files:
data = pd.read_csv(filename)
df_list.append(data)
df = pd.concat(df_list)
print(files)
As I understand this code * means occurrence of preceding letter 0 or more time. So file name ‘file*.csv’ search for filee.csv, fil.csv wait a second and also why is here we’re not escaping the functionality of .(period)
I am taking about regexp since it clearly says that we are creating regexp and searching through files. But instead it is doing different they say it search for file1.csv, file2.csv
Why do we need concatenate our DataFrames placed in df_list into one DataFrame students while there are no difference between df_list and students?
import codecademylib3_seaborn
import pandas as pd
import glob
student_files = glob.glob("exams*.csv")
df_list = []
for files in student_files:
data = pd.read_csv(files)
df_list.append(data)
students = pd.concat(df_list)
print(students)
I mean pd.concat should update our indexes but it does not. To bring such result to our code we need use option students = pd.concat(df_list, ignore_index=True)
) below.
) to up-vote the contribution!
