Read CSV Files with multiple headers into Python DataFrame

Thread Rating:

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

Thread Modes

Read CSV Files with multiple headers into Python DataFrame

UGuntupalli
Silly Frenchman

Posts: 21

Threads: 6

Joined: Jan 2017

Reputation: 0

#13

Jan-26-2017, 03:07 PM

@ All ,
Thanks for all the help so far. I tested the snippets that have been provided to me and they all work on normal files. So, the approach is correct . The issue seems to be with my file . I will have to figure out the encoding and decoding format that might be throwing it off.

Best
U

Find

Messages In This Thread

Read CSV Files with multiple headers into Python DataFrame - by UGuntupalli - Jan-23-2017, 02:31 PM

RE: Read CSV Files with multiple headers into Python DataFrame - by buran - Jan-23-2017, 03:05 PM

RE: Read CSV Files with multiple headers into Python DataFrame - by UGuntupalli - Jan-23-2017, 04:27 PM

RE: Read CSV Files with multiple headers into Python DataFrame - by buran - Jan-23-2017, 04:37 PM

RE: Read CSV Files with multiple headers into Python DataFrame - by UGuntupalli - Jan-23-2017, 05:23 PM

RE: Read CSV Files with multiple headers into Python DataFrame - by buran - Jan-23-2017, 05:43 PM

RE: Read CSV Files with multiple headers into Python DataFrame - by buran - Jan-23-2017, 07:38 PM

RE: Read CSV Files with multiple headers into Python DataFrame - by UGuntupalli - Jan-24-2017, 01:58 AM

RE: Read CSV Files with multiple headers into Python DataFrame - by buran - Jan-24-2017, 07:48 AM

RE: Read CSV Files with multiple headers into Python DataFrame - by UGuntupalli - Jan-24-2017, 02:33 PM

RE: Read CSV Files with multiple headers into Python DataFrame - by buran - Jan-24-2017, 02:54 PM

RE: Read CSV Files with multiple headers into Python DataFrame - by iFunKtion - Jan-26-2017, 02:35 PM

RE: Read CSV Files with multiple headers into Python DataFrame - by UGuntupalli - Jan-26-2017, 03:07 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Creating a Dataframe from Zenodo zip file with multiple CSVs about Spotify	man0s	0	1,353	Apr-26-2022, 01:45 PM Last Post: man0s
	Import multiple CSV files into pandas	Krayna	0	1,717	May-20-2021, 04:56 PM Last Post: Krayna
	Loading multiple JSON files to create a csv	0LI5A3A	0	2,105	Jun-28-2020, 10:35 PM Last Post: 0LI5A3A
	Can python read Marathi text files and summarize them?	mcp111	0	1,828	Mar-18-2020, 08:58 AM Last Post: mcp111
	Dividing a single column of dataframe into multiple columns based on char length	darpInd	2	2,464	Mar-14-2020, 09:19 AM Last Post: scidam
	Append Multiple CSV files	Nidhesh	2	2,502	Jul-03-2019, 11:55 AM Last Post: Nidhesh
	How to extract different data groups from multiple CSV files using python	Rafiz	3	3,242	Jun-04-2019, 05:20 PM Last Post: jefsummers
	Sum product multiple Dataframes based on column headers.	Lastwizzle	0	3,829	May-21-2019, 04:05 PM Last Post: Lastwizzle
	Grab columns from multiple files, combine into one	jon0852	0	2,019	Feb-12-2019, 02:53 AM Last Post: jon0852
	Python QtableWidget get text of all cells and headers to dataframe	Mady	3	23,189	Dec-15-2018, 06:46 PM Last Post: Axel_Erfurt

Users browsing this thread: 2 Guest(s)

View a Printable Version

Read CSV Files with multiple headers into Python DataFrame

User Panel Messages

Announcements