Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Create a dataframe from xlsx file

Highlighted

Create a dataframe from xlsx file

Hi,


I am trying to read a xlsx file and create a dataframe out of it. i have attached the xlsx file. Can anybody provide some clue on it. there are columns based on year and sub columns in it. the end goal is to create a dataframe out of it and store in a hive table for further analysis. if the year related columns are not there, then it is a straight forward one. Any thoughts or help would be great. here we have year 2004 as example and 5 columns under it. similarly there will be many years and corresponding sub columns.


107211-1552542377372.png

Don't have an account?
Coming from Hortonworks? Activate your account here