wincowgerDEV / OpenSpecy-package

Analyze, Process, Identify, and Share, Raman and (FT)IR Spectra
http://wincowger.com/OpenSpecy-package/
Creative Commons Attribution 4.0 International
26 stars 11 forks source link

csv files incorrectly read #65

Closed wincowgerDEV closed 3 years ago

wincowgerDEV commented 3 years ago

CSV files with a row number column are being read incorrectly. It is reading the row number column as wavenumber for some reason.

Example format. image

  Wavelength name Absorbance
1 649.9 MM_1706090001 A2 0.002235
2 650 MM_1706090001 A2 0.00225
3 650.1 MM_1706090001 A2 0.002265
4 650.2 MM_1706090001 A2 0.00228
5 650.3 MM_1706090001 A2 0.002296
6 650.4 MM_1706090001 A2 0.002311
7 650.5 MM_1706090001 A2 0.002326
8 650.6 MM_1706090001 A2 0.002341
9 650.7 MM_1706090001 A2 0.002414

After the row number column is removed the file reads correctly.

zsteinmetz commented 3 years ago

Whoops, my bad .. when I coded that simple column autodetection for .csv files, I haven't had row numbers in mind. I can look into it on Monday. Took a couple of days off.

wincowgerDEV commented 3 years ago

Fasho! I will look into it too.

On Thu, Apr 15, 2021 at 10:04 AM Zacharias Steinmetz < @.***> wrote:

Whoops, may bad .. when I coded that simple column autodetection for .csv files, I haven't had row numbers in mind. I can look into it on Monday. Took a couple of days off.

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com/wincowgerDEV/OpenSpecy/issues/65#issuecomment-820588040, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGMUJU3J2QNA237FGQ3INT3TI4MCDANCNFSM42724WIQ .

--

´¯·.¸¸.·´¯·.´¯·.¸¸.·´¯ツ ------------------------------

Win Cowger PhD Candidate, Environmental Sciences: Soil and Water University of California, Riverside

NSF Graduate Research Fellow Research Advisor to 5 Gyres https://www.5gyres.org/advisors/ Data Advisor to Let's Do It World https://www.letsdoitworld.org/

Contact Info

515-298-3869 | @.***

Websites www.openspecy.org www.wincowger.com http://andrewgray.ucr.edu/people/wcowger.html


zsteinmetz commented 3 years ago

Seems like read_text() wasn't made for "mixed" headers containing both named and unnamed columns.