JIYIK CN >

Pandas read_csv() method reads the specified CSVfile into DataFrame.

pandas.read_csv()grammar

pandas.read_csv(filepath_or_buffer: Union[str, pathlib.Path, IO[~ AnyStr]],
                sep=',',
                delimiter=None,
                header='infer',
                names=None,
                index_col=None,
                usecols=None,
                squeeze=False,
                prefix=None,
                mangle_dupe_cols=True,
                dtype=None,
                engine=None,
                converters=None,
                true_values=None,
                false_values=None,
                skipinitialspace=False,
                skiprows=None,
                skipfooter=0,
                nrows=None,
                na_values=None,
                keep_default_na=True,
                na_filter=True,
                verbose=False,
                skip_blank_lines=True,
                parse_dates=False,
                infer_datetime_format=False,
                keep_date_col=False,
                date_parser=None,
                dayfirst=False,
                cache_dates=True,
                iterator=False,
                chunksize=None,
                compression='infer',
                thousands=None,
                decimal: str='.',
                lineterminator=None,
                quotechar='"',
                quoting=0,
                doublequote=True,
                escapechar=None,
                comment=None,
                encoding=None,
                dialect=None,
                error_bad_lines=True,
                warn_bad_lines=True,
                delim_whitespace=False,
                low_memory=True,
                memory_map=False,
                float_precision=None)

parameter

Return Value

Dataframe formed from a CSV file with labeled axes.

Example code: Pandas uses pandas.read_csv()the function to read CSVfiles

import pandas as pd
df = pd.read_csv("dataset.csv")
print(df)

Output:

       Country      Item Type Sales Channel Order Priority
0       Tuvalu      Baby Food       Offline              H
1   East Timor           Meat        Online              L
2       Norway      Baby Food        Online              L
3     Portugal      Baby Food        Online              H
4     Honduras         Snacks        Online              L
5  New Zealand         Fruits        Online              H
6     Moldova   Personal Care        Online              L

This method CSVloads the file into DataFrame. Here, we can use both absolute and relative paths to provide a file path as pandas.read_csv()a parameter of the function.

In this case, dataset.csvit is in the same directory as the program file, which means that you can use CSVthe file name as the file path.

Example code: pandas.read_csv()Setting usecolsparameters in a function

import pandas as pd
df = pd.read_csv("dataset.csv",usecols=["Country","Sales Channel","Order Priority"])
print(df)

Output:

       Country Sales Channel Order Priority
0       Tuvalu       Offline              H
1   East Timor        Online              L
2       Norway        Online              L
3     Portugal        Online              H
4     Honduras        Online              L
5  New Zealand        Online              H
6     Moldova         Online              L

This example loads a file into by including only usecolsthe specified columns in the parameter .CSVDataFrame

Country, Sales Channeland Order Prioritythese columns are only passed as parameters, so they are only included in DataFrame.

pandas.read_csv()Example code: Function with header

import pandas as pd
df = pd.read_csv("dataset.csv",header=1)
print(df)

Output:

        Tuvalu      Baby Food Offline  H
0   East Timor           Meat  Online  L
1       Norway      Baby Food  Online  L
2     Portugal      Baby Food  Online  H
3     Honduras         Snacks  Online  L
4  New Zealand         Fruits  Online  H
5     Moldova   Personal Care  Online  L

headerThe procedure loads CSVthe file into by setting line 1 to DataFrame.

Here, the first row elements are used as DataFramethe column names of the entire .

pandas.read_csv()Example code: Function with line skipping

import pandas as pd
df = pd.read_csv("dataset.csv",skiprows=3)
print(df)

Output:

        Norway      Baby Food  Online  L
0     Portugal      Baby Food  Online  H
1     Honduras         Snacks  Online  L
2  New Zealand         Fruits  Online  H
3     Moldova   Personal Care  Online  L

This process loads the CSV file into a DataFrame by skipping the first 3 rows.