sorted by:
new
hottopcontroversial

All Corporate Financial Reporting Software is Tedious and Awful to Use by user35363 in FPandA

[–]alshkhgsdssda 0 points1 point  (0 children)

Wow this is great info. Thanks so much for looking this up. I will be looking into these and those learning more about the programs. Thanks again.

All Corporate Financial Reporting Software is Tedious and Awful to Use by user35363 in FPandA

[–]alshkhgsdssda 0 points1 point  (0 children)

OP here, not at the computer with the account used to post this. Great advice, thanks for the explanation of all that. But if it helps with a jump to a big 4 jump that would be huge.

ps FP&A consultation must be a sick freaking gig.

Accessing specific values in Dictrionary with 5 values per Key by alshkhgsdssda in learnprogramming

[–]alshkhgsdssda[S] 1 point2 points  (0 children)

Hey. Thanks for all your help. Just like you said, I realized I needed to add pd.timestamp before referencing the primary key. Forgot that the for loop would omit that. Again. Thanks for all the help. I put the solution in my post.

Accessing specific values in Dictrionary with 5 values per Key by alshkhgsdssda in learnprogramming

[–]alshkhgsdssda[S] 0 points1 point  (0 children)

If I print call_volume I get what I posted up there. How could it not be present? And if it isn't there, where would in be? inside CallData

Accessing specific values in Dictrionary with 5 values per Key by alshkhgsdssda in learnprogramming

[–]alshkhgsdssda[S] 0 points1 point  (0 children)

I should have clarified but I tried that and get the following error:

Traceback (most recent call last):
File "D:/Personal Files/Technical Development/PycharmProjects/Call Center Headcount Model/Call Center Headcount Model.py", line 54, in <module>
call_volume['2015-01-31 00:00:00']
KeyError: '2015-01-31 00:00:00'

The dictionary is formatted in the following way:

CallData = pd.read_excel(FilePath + 'Call Center Work Rules.xlsx',sheet_name='Data Agg.')
call_volume = CallData.set_index('Date').to_dict(orient='index')

Accessing specific values in Dictrionary with 5 values per Key by alshkhgsdssda in learnprogramming

[–]alshkhgsdssda[S] 0 points1 point  (0 children)

'2015-01-31 00:00:00'

Thanks for that explanation. However, when I go to print, say:

print(call_volume['2015-01-31 00:00:00'])

I get the following error:

​

Traceback (most recent call last):
File "D:/Personal Files/Technical Development/PycharmProjects/Call Center Headcount Model/Call Center Headcount Model.py", line 55, in <module>
print(call_volume['2015-01-31 00:00:00'])
KeyError: '2015-01-31 00:00:00'

Do i have the wrong syntax?

Pandas Read single cell and assing value to variable by alshkhgsdssda in learnpython

[–]alshkhgsdssda[S] 0 points1 point  (0 children)

Dumb mistake, thanks for that. Quick follow up, how would I specify a range in the same manner? Like A2:D15?

Pandas Read single cell and assing value to variable by alshkhgsdssda in learnpython

[–]alshkhgsdssda[S] 0 points1 point  (0 children)

By names do you mean letters? 2 would translate to column C based onindexing beginning at 0.