Home > Backend Development > Python Tutorial > How Can I Import a CSV File into a Pandas DataFrame?

How Can I Import a CSV File into a Pandas DataFrame?

Mary-Kate Olsen
Release: 2024-12-13 03:36:15
Original
957 people have browsed it

How Can I Import a CSV File into a Pandas DataFrame?

Pandas: Importing CSV Files as DataFrames

To import a CSV file as a Pandas DataFrame, the solution is quite simple. Pandas provides a convenient read_csv function that takes care of this task.

Import the data

import pandas as pd
Copy after login

Read the CSV file

To read the given CSV file into a DataFrame, use the read_csv function:

df = pd.read_csv("data.csv")
Copy after login

Output the DataFrame

Once the data is read, you can print the DataFrame to view its contents:

print(df)
Copy after login

This will output the CSV data as a DataFrame with the following columns:

  • Date
  • "price"
  • "factor_1"
  • "factor_2"

And their corresponding values. Here's an example output:

        Date    price  factor_1  factor_2
0  2012-06-11  1600.20     1.255     1.548
1  2012-06-12  1610.02     1.258     1.554
2  2012-06-13  1618.07     1.249     1.552
3  2012-06-14  1624.40     1.253     1.556
4  2012-06-15  1626.15     1.258     1.552
5  2012-06-16  1626.15     1.263     1.558
6  2012-06-17  1626.15     1.264     1.572
Copy after login

The above is the detailed content of How Can I Import a CSV File into a Pandas DataFrame?. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template