I am new to Mathematica and was looking for some help.
I have successfully imported an excel sheet as a dataset, however, I wanted to manipulate the dataset but realised I need a key to do so. When I imported them, the two columns of data appeared as a dataset, however, with no key. How can I assign a key to each column? It is not possible to directly assign this as there are hundreds of rows of data.
Is there a way to assign the key when importing the data or even to do this after?
If the Excel file has column headers use
Import[<file>, {"Dataset", 1}, HeaderLines -> 1]
If it does not then after the import
headers = {"Date", "Cases"}; ds[All, AssociationThread[headers, #] &]
where ds is the imported Dataset.
ds
Dataset
It would be easier to help if you provided:
The code you posted is too much of a mess to try to untangle, and I suspect that you've modified your actual code to try to simplify your question. So, it'd just be easier if you explain what you have and what your objective is.
Welcome to Wolfram Community! Please make sure you know the rules: https://wolfr.am/READ-1ST
The rules explain how to format your code properly. Posting code Images doesn't help other members to copy your code. Please EDIT your post and make sure code blocks start on a new paragraph and look framed and colored like this.
int = Integrate[1/(x^3 - 1), x]; Map[Framed, int, Infinity]
You can also embed notebook or attach notebook.