String to List question help

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

String to List question help

deanhystad

Super Moderators

Posts: 6,330

Threads: 16

Joined: Feb 2020

Reputation: 315

Sep-06-2023, 02:32 PM (This post was last modified: Sep-06-2023, 02:32 PM by deanhystad.)

The screenshot looked like tabs. That is another advantage of posting text over screenshots. I would have known the columns were separated by spaces, sometimes multiple spaces. Again, not a problem. Pandas if accommodating. Change the separator to a space, and skipinitialspace to take care of when there are multiple spaces between columns.

df = pd.read_csv(StringIO(gpib_string), sep=" ", skiprows=5, names=columns, skipinitialspace=True)

James_Thomas likes this post

Find

Messages In This Thread

String to List question help - by James_Thomas - Sep-05-2023, 03:52 PM

RE: String to List question help - by deanhystad - Sep-05-2023, 06:45 PM

RE: String to List question help - by James_Thomas - Sep-06-2023, 09:14 AM

RE: String to List question help - by Pedroski55 - Sep-06-2023, 10:59 AM

RE: String to List question help - by deanhystad - Sep-06-2023, 12:22 PM

RE: String to List question help - by James_Thomas - Sep-06-2023, 01:17 PM

RE: String to List question help - by deanhystad - Sep-06-2023, 02:32 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	syntax error question - string	mgallotti	5	1,479	Feb-03-2023, 05:10 PM Last Post: mgallotti
	General programming question (input string)[	jamie_01	2	1,691	Jan-08-2022, 12:59 AM Last Post: BashBedlam
	Question about change hex string to integer sting in the list (python 2.7)	lzfneu	1	2,616	May-24-2021, 08:48 AM Last Post: bowlofred
	Question on HTML formatting with set string in message	Cknutson575	3	3,605	Mar-09-2021, 08:11 AM Last Post: Cknutson575
	question: finding multiple strings within string	djf123	4	3,075	May-16-2020, 01:00 PM Last Post: snippsat
	Simple newb string question	Involute	2	2,324	Sep-08-2019, 12:50 AM Last Post: Involute
	string parsing question ( I think)	diggee17	4	3,136	Jul-24-2019, 02:37 PM Last Post: diggee17
	I converted string to 'list', but it doesn't look like a list!	mrapple2020	3	3,349	Apr-07-2019, 02:34 PM Last Post: mrapple2020
	please help with this question about using operators to multiply a string?	GilesTwigg	3	4,503	Feb-27-2019, 04:13 PM Last Post: ichabod801
	about List question	longmail	2	2,467	Nov-30-2018, 02:08 AM Last Post: longmail

Users browsing this thread: 1 Guest(s)

View a Printable Version

String to List question help

User Panel Messages

Announcements