'CSV dataframe doesn't match with dataframe generated from URL

I have a file that I download from NERL API. When I try to compare it with older csv I get a difference using .equals command in padas but both files are 100% same. the only difference is one data frame is generated from CSV and another is directly from API URL.

Below is my code, why is there a difference?

import pandas as pd
NERL_url = "https://developer.nrel.gov/api/alt-fuel-stations/v1.csv?api_key=DEMO_KEY&fuel_type=ELEC&country=all" 
outputPath = r"D:\<myPCPath>\nerl.csv"
urlDF = pd.read_csv(NERL_url, low_memory=False)
urlDF.to_csv(outputPath, header=True,index=None, encoding='utf-8-sig')

csv_df = pd.read_csv(outputPath, low_memory=False)  


if csv_df.equals(urlDF):
    print("Same")
else:
    print("Different")

My output is coming as Different. How do I fix this and why is this difference comming?

python pandas csv

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'CSV dataframe doesn't match with dataframe generated from URL

Sources

Related Questions