[Solved] Using readlines to read data file and sum columns

Thread Rating:

Thread Modes

[Solved] Using readlines to read data file and sum columns

paul18fr
Spam, spam, eggs, and spam

Posts: 256

Threads: 60

Joined: Apr 2019

Reputation: 5

Jun-16-2021, 09:27 AM

It's a feeling but I guess you should first convert your data into float or int (your data are string) prior to use numpy

d1first = np.sum(float(firstlines[:,1]))

Messages In This Thread

RE: Using readlines to read data file and sum columns - by paul18fr - Jun-16-2021, 09:27 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Connecting to Remote Server to read contents of a file	ChaitanyaSharma	1	150	Yesterday, 07:23 AM Last Post: Pedroski55
	Help with to check an Input list data with a data read from an external source	sacharyya	3	444	Mar-09-2024, 12:33 PM Last Post: Pedroski55
	[SOLVED] Correct way to convert file from cp-1252 to utf-8?	Winfried	8	1,034	Feb-29-2024, 12:30 AM Last Post: Winfried
	Create Choices from .ods file columns	cspower	3	644	Dec-28-2023, 09:59 PM Last Post: deanhystad
	Recommended way to read/create PDF file?	Winfried	3	2,938	Nov-26-2023, 07:51 AM Last Post: Pedroski55
	python Read each xlsx file and write it into csv with pipe delimiter	mg24	4	1,529	Nov-09-2023, 10:56 AM Last Post: mg24
	Create csv file with 4 columns for process mining	thomaskissas33	3	796	Nov-06-2023, 09:36 PM Last Post: deanhystad
	read file txt on my pc to telegram bot api	Tupa	0	1,157	Jul-06-2023, 01:52 AM Last Post: Tupa
	parse/read from file seperated by dots	giovanne	5	1,144	Jun-26-2023, 12:26 PM Last Post: DeaD_EyE
	Formatting a date time string read from a csv file	DosAtPython	5	1,364	Jun-19-2023, 02:12 PM Last Post: DosAtPython

Users browsing this thread: 1 Guest(s)