'"Thousands" and " skip_blank_lines" arguments of pandas.read_csv would not work properly. Why?

This my code:

in[0]
      import pandas as pd
      df = pd.read_csv('datefile6.csv',thousands=',', skip_blank_lines=True)
      df

out[1]      month   day     year    salary   age
       0    8.0     15.0    2012.0  1400.0   25.0
       1    NaN     NaN     NaN     NaN      NaN
       2    9.0     4.0     2020.0  2500.0   26.0

As we see the thousands did not work. Also, line[1] which is blank has not been skipped by the commands.

I expected ',' from the "thousands" command and removed line[1] from the "skip_blan_lines" command.

Sources

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

Source: Stack Overflow

Solution	Source

'"Thousands" and " skip_blank_lines" arguments of pandas.read_csv would not work properly. Why?

Sources

Related Questions