DOC: change `tuples` param for MultiIndex.from_tuples from sequence to iterable

[yangdanny97]

Pandas version checks

• I have checked that the issue still exists on the latest versions of the docs on main here

Location of the documentation

https://pandas.pydata.org/docs/reference/api/pandas.MultiIndex.from_tuples.html#pandas.MultiIndex.from_tuples

The docs currently say this for the tuples parameter:

list / sequence of tuple-likes

Documentation problem

Pandas-stubs annotates the parameter as sequence: https://github.com/pandas-dev/pandas-stubs/blob/main/pandas-stubs/core/indexes/multi.pyi#L49

Pandas source code annotates the parameter as iterable: https://github.com/pandas-dev/pandas/blob/main/pandas/core/indexes/multi.py#L521

Typing the parameter as sequence prevents this pattern from typechecking, even if it works at runtime:

MultiIndex.from_tuples(zip(['a'], ['b']))

This was raised in pandas-dev/pandas-stubs#1158

Suggested fix for documentation

Could we loosen the type annotation in the docs to say iterable? Then I can update pandas-stubs to match.

[rhshadrach]

Could we loosen the type annotation in the docs to say iterable?

I think no - the code raises on inputs that aren't list-like (pandas considers generators as list-like). Currently the code does not raise on sets, but I believe it should. I think the docs should be something like list-like excluding sets and the behavior of pandas changed to match.

Also this is the only occurrence in pandas of tuple-likes and I'm not sure what that means. MultiIndex.from_tuples([[1, 2]]) does not raise, is a list "tuple-like"?

cc @Dr-Irv

[Dr-Irv]

This relates to a comment I made here: #55425 (comment)

I agree with the idea of removing tuple-like and using list-like in the docs, which means we could include a generator.