Python Forum
Dealing with Exponential data
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Dealing with Exponential data
#1
Having csv file with the value as below
2.22971E+15,2.20408E+15
while reading from csv able to read the data as
'2229708157109627', '2204081406354342'
code:
import pandas as pd
with open('mypath\mycsv.csv', encoding="utf8") as csv_file:
    df = pd.read_csv(csv_file,index_col=None, header=0) 
but actually
2229708157109620, 2204081406354340

Why the values are changing here
from 2229708157109620 to 2229708157109627
from 2204081406354340 to 2204081406354342
?
Reply


Messages In This Thread
Dealing with Exponential data - by parthi1705 - May-29-2019, 10:07 AM
RE: Dealing with Exponential data - by buran - May-29-2019, 10:20 AM
RE: Dealing with Exponential data - by parthi1705 - May-29-2019, 10:25 AM
RE: Dealing with Exponential data - by buran - May-29-2019, 10:40 AM
RE: Dealing with Exponential data - by parthi1705 - May-30-2019, 04:27 AM
RE: Dealing with Exponential data - by buran - May-29-2019, 11:02 AM
RE: Dealing with Exponential data - by DeaD_EyE - May-29-2019, 01:45 PM
RE: Dealing with Exponential data - by buran - May-30-2019, 06:48 AM
RE: Dealing with Exponential data - by parthi1705 - May-30-2019, 09:06 AM
RE: Dealing with Exponential data - by buran - May-30-2019, 09:16 AM
RE: Dealing with Exponential data - by parthi1705 - May-30-2019, 09:58 AM
RE: Dealing with Exponential data - by buran - May-30-2019, 10:16 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Excel from SAP - dealing with formats and VBA MasterOfDestr 7 551 Feb-25-2024, 12:23 PM
Last Post: Pedroski55
  UnicodeEncodeError - Dealing with Japanese Characters fioranosnake 2 2,446 Jul-07-2022, 08:43 PM
Last Post: fioranosnake
  how to get non-exponential format Skaperen 1 1,438 Nov-21-2021, 08:51 PM
Last Post: bowlofred
  Dealing with duplicated data in a CSV file bts001 10 11,460 Sep-06-2021, 12:11 AM
Last Post: SamHobbs
  Dealing with a .json nightmare... ideas? t4keheart 10 4,380 Jan-28-2020, 10:12 PM
Last Post: t4keheart
  understanding exponential and bitwise operators srm 1 2,044 Jun-15-2019, 11:14 AM
Last Post: ThomasL
  Dealing with multiple context managers heras 5 4,692 Nov-16-2018, 09:01 AM
Last Post: DeaD_EyE
  dealing with big data of timestamp LMQ 0 2,167 Jul-27-2018, 01:23 PM
Last Post: LMQ
  dealing with spaces in file names AceScottie 5 75,108 Jun-02-2018, 01:06 PM
Last Post: AceScottie
  Dealing with strings thru mmap in Python doublezero 4 8,028 Mar-01-2017, 06:33 PM
Last Post: zivoni

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020